Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

looking for word parts with full text search in sql server

Tags:

sql

sql-server

how do I find, with full text search all words that match 'ability' mask, like "suitability" and "dependability", etc? is that possible?

like image 335
Greg Avatar asked Nov 05 '22 13:11

Greg

1 Answers

It's not possible out of the box. Apparently wildcards do not work. See here for discussion.

like image 160
mdma Avatar answered Nov 12 '22 17:11

mdma
Sign in to Comment

Related questions

How to efficiently archive older parts of a big (multi-GB) SQL Server database?
Determine Time Zone Offset in T-SQL
How do I load and save an image from an SQL Server database using GDI+ and C++?
Cascading Deletes/Updates using JPA or Inside of Database?
Ad hoc data and repository pattern
How to find the *position* of a single record in a limited, arbitrarily ordered record set?
Windows Desktop Search via C#
Find duplicate/repeated rows in hierarchical sql
SQL Server - Get Inserted Record Identity Value when Using a View's Instead Of Trigger
Error when calling renderstream in reporting services 2008 webservice
Advanced SQL query. Top 12 from each category (MYSQL)
SQL: Quickly getting the value of column B wherever column A is minimum
How to present features of aggregate functions (NULL)?
T-SQL: Omit/Ignore repetitive data from a specific column
Select longest common timerange
How do you optimize database performance when providing results for autocomplete/iterative search?
How do I get the entity framework to work with archive flags?
Which third party tools/library are available for NoSQL databases?
SQL Server - Schema/Code Analysis Rules - What would your rules include?
Need help with a conditional SELECT statement

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!