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

73 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
drillability185463(None) 
drinkability2254692drinkability
drivability2046792dri_vability
driveability2155092driveability
coilability1847933coi_lability
dilatability1845453d_ilatability
disability1649773d_i_sability
drapability1986473dr_apability
drapeability2055913drapeability
drillabilities1754803drillabilities
friability1847893fri__ability
mailability1847303mai_lability
printability1946863printability
reliability1649463_reliability
violability1946273_violability
admirability2055714admi_rability
advisability2155064advi_sability
alienability1745694alienability
amiability1748744ami__ability
amicability2047324ami_cability
arability14411014ar___ability
availability2055494availability
biddability2043844_biddability
brushability2253784brushability
crossability1956104crossability
culpability2045294_culpability
decidability2145744decidability
deniability1748724d_eniability
desirability1847274desirability
detonability1856144detonability
drillable1245134drillab_l__e
durability1647734d__urability
dyeability1945884d__yeability
erasability1668934er_asability
fallibility1953894_fallibility
fishability2245284_fishability
gullibility1753124_gullibility
heritability2047984heri_tability
inability14411104__i_nability
inviolability2155114inviolability
irritability1747484irritability
lability13710834____lability
liability14128484___liability
likability1996124_li_kability
livability1886744_li_vability
liveability1945794_liveability
malleability1954844malleability
meltability1848684_meltability
modulability2064214modulability
palpability2046334_palpability
perishability2365234perishability
pliability1748054__pliability
pregnability2056164pregnability
probability2047704pr_obability
readability1748074_readability
recallability2054504recallability
rentability16410194_rentability
reusability1648474_reusability
risibility1547544_ri_sibility
roadability1757204_roadability
salability1548524__salability
solvability1946414_solvability
suitability1647114sui_tability
syllabicity2152784_syllabicity
traceability1956534traceability
tractability1947094tractability
trainability1746854trainability
treatability1747434treatability
trustability1756134trustability
unreliability1855604unreliability
variability1947524vari__ability
verifiability2454444verifiability
viability1767874_vi__ability

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.420425454.8
2DLD Change Limit124790736.44019377.3
3Display Results73730.0302433.3
 (SQL Overall)178691736.89025934.8
 
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.