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 “compatibilitiesa” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

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
compatibilities2363621compatibilities_
comparabilities2374373comparabilities_
computabilities2354543computabilities_
compatibility2453974compatibilit___y
capabilities1848825c_apa__bilities_
coilabilities1748095coila__bilities_
compatibleness2262615compatib_l_eness
compatibles19134145compatib_l___es_
corrigibilities2092765corrigibilities_
countabilities1856695co_untabilities_
culpabilities1946025culpa__bilities_
impassibilities21184675_impassibilities_
imputabilities2056625_imputabilities_
partibilities1748095___partibilities_
acceptabilities2354236accep_tabilities_
adaptabilities1955636adap_tabilities_
admissibilities2063326admissibilities_
adoptabilities1955276adop_tabilities_
amiabilities16109896_amia__bilities_
castabilities1748836c__astabilities_
cleanabilities1856056c_leanabilities_
coagulabilities2062736coagulabilities_
codifiabilities2383046codifiabilities_
collateralities17152336collateralities_
comicalities1846976com___icalities_
commutativities2471506commutativities_
comparability2454906comparabilit___y
compatible18125576compatib_l___e__
complicities2055966comp___licities_
compulsivities2361916comp_ulsivities_
computability2455156computabilit___y
connaturalities17162606connaturalities_
credibilities1856076c__redibilities_
creditabilities2065296creditabilities_
crossabilities1855726crossa__bilities_
curabilities1649406c_ura__bilities_
cutabilities1649146c___utabilities_
deductibilities2183066deductibilities_
defeasibilities2153816defeasibilities_
digestibilities1963286digestibilities_
dilatabilities1795946_dilatabilities_
drapabilities1847116drapa__bilities_
expansibilities2693386_expansibilities_
feasibilities1866566__feasibilities_
formabilities2047006forma__bilities_
immiscibilities2363396immiscibilities_
immutabilities2056056_immutabilities_
impalpabilities2363956_impalpabilities_
impartialities1863496_imparti_alities_
impassabilities21155266_impassabilities_
implacabilities2354016_implacabilities_
impossibilities21174236_impossibilities_
incompatibility2662626incompatibilit___y
infeasibilities2064726infeasibilities_
insatiabilities1775506_insatiabilities_
lovabilities1788006lo_va__bilities_
meltabilities1749876__meltabilities_
miscibilities1955716__miscibilities_
movabilities1978366mo_va__bilities_
mutabilities1649556__m_utabilities_
notabilities14410736no___tabilities_
openabilities1748626_o_penabilities_
operabilities17510056_o_perabilities_
opposabilities2054916_opposabilities_
optimalities1654666_o_p_timalities_
palatabilities1846806_palatabilities_
palpabilities1947256palpa__bilities_
portabilities17410216po__rtabilities_
possibilities1756066po__ssibilities_
potabilities16411316___potabilities_
promotabilities2184556prom_otabilities_
repeatabilities1955916repeatabilities_
reputabilities1847436_reputabilities_
resistibilities1753986resistibilities_
roadabilities1647816ro__adabilities_
separabilities1847346_separabilities_
sociabilities1748406socia__bilities_
solvabilities1846896solva__bilities_
sorbabilities1746996sorba__bilities_
spatialities1465566__spati_alities_
summabilities1975646summa__bilities_
treatabilities1657626_treatabilities_
volatilities1546516vo_lat__ilities_
workabilities2245676worka__bilities_

Search took 7 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.326548131.9
2DLD Change Limit65874846.33010406.6
3Display Results84840.0631333.3
 (SQL Overall)178691846.71926594.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.