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

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

74 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
etchants134602(None) 
enchants1347831enchants
etchant1249821etchant_
chants115020392__chants
enchant12313132enchant_
etchings14396292etchings
ethanes103713512et_hanes
merchants1646222merchants
penchants1646202penchants
bacchants1845023bacchants
bethanks1765313bet_hanks
cants77036943__c_ants
changs125215373__changs
chant105932693__chant_
chanty145215823__chanty
charts115823093__charts
chats105730093__cha_ts
chaunts1267083__chaunts
chints115117833__chints
decants103514443dec_ants
descants112910143desc_ants
echards1337963e_chards
echinus1236203e_chinus
eclats8313033e_cla_ts
elephants1444803elephants
eluants737583e_luants
enchains1348523enchains
enchanted1546553enchanted
enchanter1446193enchanter
enchanters1545223enchanters
enchases13310273enchases
entrants8311753entrants
errants7410643e_rrants
eschalots1444133eschalots
eschars1237183escha_rs
escheats1346253escheats
etchers123411293etch_ers
etches114217763etch__es
etching134511843etchin_g
ethane94613243et_han_e
ethanol1044593et_hanol
ethanols1144333et_hanols
ethenes103313873et_henes
ethnos947053et_h_nos
ethynes13377573et_hynes
eucharis1347443eucharis
evacuants1442953evacuants
exchange21124323exchange
exchanges22124613exchanges
excitants1864393excitants
explants1737023explants
hants86335403___hants
incants92012803inc_ants
itchings14386193itchings
lochans1248833lochan_s
merchant1548823merchant_
methanes133812163met_hanes
octants9128733_octants
pechans14810503pechan_s
penchant1549593penchant_
pschents1544113pschents
reactants1146623reactants
recants93217093rec_ants
recharts1337663recharts
retirants947323retirants
scants85219723_sc_ants
secants93413893sec_ants
setenants945973setenants
technos1236183tech_nos
tenants7311013_tenants
thanes94918983_t_hanes
thanks134313133_t_hanks
truants738163_truants
tyrants1037453_tyrants

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 Filter1786911461620.436409841.7
2DLD Change Limit146162747.50019488.3
3Display Results74740.0164625.0
 (SQL Overall)178691747.95222471.2
 
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.