Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “compatibilities” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
compatibilities236362(None) 
comparabilities2374372comparabilities
computabilities2354542computabilities
compatibility2453973compatibilit__y
capabilities1848824c_apa__bilities
coilabilities1748094coila__bilities
compatibles19134144compatib_l___es
corrigibilities2092764corrigibilities
countabilities1856694co_untabilities
culpabilities1946024culpa__bilities
impassibilities21184674_impassibilities
imputabilities2056624_imputabilities
partibilities1748104___partibilities
acceptabilities2354235accep_tabilities
adaptabilities1955635adap_tabilities
admissibilities2063325admissibilities
adoptabilities1955275adop_tabilities
amiabilities16109895_amia__bilities
castabilities1748835c__astabilities
cleanabilities1856055c_leanabilities
coagulabilities2062735coagulabilities
codifiabilities2383045codifiabilities
collateralities17152335collateralities
comicalities1846975com___icalities
commutativities2471505commutativities
comparability2454905comparabilit__y
compatible18125575compatib_l___e_
compatibleness2262615compatib_leness
complicities2055965comp___licities
compulsivities2361915comp_ulsivities
computability2455155computabilit__y
connaturalities17162605connaturalities
credibilities1856075c__redibilities
creditabilities2065295creditabilities
crossabilities1855725crossa__bilities
curabilities1649405c_ura__bilities
cutabilities1649145c___utabilities
deductibilities2183065deductibilities
defeasibilities2153815defeasibilities
digestibilities1963285digestibilities
dilatabilities1795945_dilatabilities
drapabilities1847115drapa__bilities
expansibilities2693385_expansibilities
feasibilities1866565__feasibilities
formabilities2047005forma__bilities
immiscibilities2363395immiscibilities
immutabilities2056055_immutabilities
impalpabilities2363955_impalpabilities
impartialities1863495_imparti_alities
impassabilities21155265_impassabilities
implacabilities2354015_implacabilities
impossibilities21174235_impossibilities
incompatibility2662625incompatibilit__y
infeasibilities2064725infeasibilities
insatiabilities1775505_insatiabilities
lovabilities1788005lo_va__bilities
meltabilities1749875__meltabilities
miscibilities1955715__miscibilities
movabilities1978365mo_va__bilities
mutabilities1649555__m_utabilities
notabilities14410735no___tabilities
openabilities1748625_o_penabilities
operabilities17510055_o_perabilities
opposabilities2054915_opposabilities
optimalities1654665_o_p_timalities
palatabilities1846805_palatabilities
palpabilities1947255palpa__bilities
portabilities17410215po__rtabilities
possibilities1756065po__ssibilities
potabilities16411315___potabilities
promotabilities2184555prom_otabilities
repeatabilities1955915repeatabilities
reputabilities1847435_reputabilities
resistibilities1753985resistibilities
roadabilities1647815ro__adabilities
separabilities1847345_separabilities
sociabilities1748405socia__bilities
solvabilities1846895solva__bilities
sorbabilities1746995sorba__bilities
spatialities1465565__spati_alities
summabilities1975645summa__bilities
treatabilities1657625_treatabilities
volatilities1546515vo_lat__ilities
workabilities2245675worka__bilities

Search took 5 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691658740.330541487.9
2DLD Change Limit65874844.36015108.7
3Display Results84840.0761105.3
 (SQL Overall)178691844.76637492.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.