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

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

95 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
adaptability205522(None) 
adoptability2054761adoptability
acceptability2454123acceptability
actability1749083__actability
adaptabilities1955633adaptabilities
adaptivity1952543adapt__ivity
adjustability2652983adjustability
admirability2055713admirability
adorability1746903ad_orability
advisability2155063advisability
availability2055493availability
capability1947593_cap_ability
castability1848413_castability
drapability1986473drap_ability
drapeability2055913drapeability
palatability1946383pala_tability
tractability1947093tractability
adaptable1444614adaptab_l__e
adoptabilities1955274adoptabilities
affability2145684__affability
affectability2663854affectability
agreeability1855164agreeability
alienability1745694alienability
alterability1747124alterability
amenability1847494a_menability
amiability1748744__amiability
amicability2047324a_micability
analyzability3053424analyzability
arability14411014__a_rability
assumability1954024assumability
attainability18103984attainability
bankability2245244_bankability
bearability1847334bea_rability
computability2455154computability
countability1956584countability
culpability2045294culp_ability
cutability1747864__cutability
damageability2253194damageability
deniability1748724_deniability
dilatability1845454dilatability
disability1649774_d_isability
drivability2046794_drivability
durability1647734_d_urability
dyeability1945884_d_yeability
educability1946244ed_ucability
electability1947054electability
equitability2645774equitability
erasability1668934era_sability
excitability2655674excitability
flammability2453904flammability
habitability2255094habitability
heritability2047984heritability
ignitability1856054ignitability
immutability2155894immutability
imputability2146384imputability
incapability2156514incap_ability
instability1649444_instability
irritability1747484irritability
leachability2255254leachability
mailability1847304_mailability
manageability2153914manageability
marketability2454134marketability
meltability1848684_meltability
metastability2055574metastability
mutability1748074__mutability
notability1549704__notability
packability2446044_packability
palpability2046334_palpability
partibility1847114_partibility
patentability2054784patentability
placability2047144pla_cability
playability2146024pla_yability
portability1849564_portability
potability1749814__potability
printability1946864printability
quotability2555594_quotability
readability1748074rea_dability
rentability16410194_rentability
reputability1946984reputability
roadability1757204roa_dability
salability1548524_sa_lability
separability1946914separability
shareability2054924shareability
stability14410084___stability
stainability1755684stainability
suitability1647114_suitability
testability1648804_testability
traceability1956534traceability
trainability1746854trainability
treatability1747434treatability
trustability1756134trustability
variability1947524_variability
washability2245324_washability
wearability1947104wea_rability
wettability1946484_wettability

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 Filter1786911247900.390458182.1
2DLD Change Limit124790956.36019621.1
3Display Results95950.0631507.9
 (SQL Overall)178691956.81326227.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.