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 “cleanability” 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.

81 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
cleanability195522(None) 
alienability1745693alienability
amenability1847493ame_nability
bearability1847333_bearability
capability1947593c__apability
cleanabilities1856053cleanabilities
electability1947053electability
leachability2255253_leachability
openability1846933ope_nability
placability2047143pl_acability
playability2146023pl_ayability
pregnability2056163pregnability
readability1748073_readability
tenability1549123_te_nability
treatability1747433treatability
wearability1947103_wearability
acceptability2454124acceptability
alterability1747124alterability
appealability2253964appealability
arability14411014___arability
attainability18103984attainability
bankability2245244__bankability
breathability2354084breathability
castability1848414c_astability
changeability2453344c_hangeability
cleanable1345204cleanab_l__e
coilability1847934c_oilability
comparability2454904comparability
countability1956584countability
credibility1955504cre_dibility
creditability2155694creditability
crossability1956104crossability
culpability2045294c_ulpability
cultivability2373684cultivability
curability1747864c__urability
cutability1747864c__utability
delectability2155674delectability
deniability1748724_deniability
detonability1856144detonability
dilatability1845454dilatability
drapability1986474_drapability
dyeability1945884dye__ability
equability2446744__equability
erasability1668934_erasability
expandability2853694expandability
feasibility1945954_feasibility
flammability2453904flammability
flexibility2653294fle_xibility
inability14411104___inability
incapability2156514incapability
ineffability2356394ineffability
lability13710834_l___ability
legibility1645914_le_gibility
liability14128484_l__iability
likability1996124_l_ikability
livability1886744_l_ivability
liveability1945794_liveability
lovability18106934_l_ovability
meltability1848684_meltability
obtainability2053574obtainability
operability1848854ope_rability
palatability1946384palatability
pleasurability2171954pleasurability
pliability1748054pl__iability
reasonability1854794_reasonability
reliability1649464_reliability
rentability16410194_rentability
repeatability2056244repeatability
reusability1648474_reusability
roadability1757204_roadability
salability1548524__salability
separability1946914separability
sewability1846854_se_wability
spreadability2154404spreadability
stainability1755684stainability
testability1648804_testability
tolerability1776294tole_rability
trainability1746854trainability
tunability1546984__tunability
untenability1756424untenability
wettability1946484_wettability

Search took 8 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 Limit124790816.73618525.8
3Display Results81810.0431883.7
 (SQL Overall)178691817.16924925.5
 
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.