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

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

100 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
harden10571853(None) 
garden84215081garden
hardens113815021hardens
harder105022401harder
harken135116341harken
warden104515511warden
ardeb8314522_ardeb
ardent73022612_ardent
arpen74418042_arpen
barde85330772barde_
barded105426422barded
bardes95026932bardes
barmen105418532barmen
barren85317612barren
burden9412472burden
carded105424902carded
carder94524182carder
cardon94120852cardon
careen84119492careen
carmen104019342carmen
carven114716662carven
darken114013442darken
farded114518952farded
fardel104712592fardel
gardens93312092gardens
hade85440192ha_de_
haded105227622ha_ded
hades96035112ha_des
hadron102913752hadron
haen76229452ha__en
hagdon1188282hagdon
handed114919982handed
hander104526432hander
happen134812192happen
hapten115312982hapten
hard85443502hard__
hardened1338612hardened
hardener1238882hardener
hardest113118412hardest
hardier114721542hardier
hardies114923232hardies
hardly135112832hardly
hardpan1336442hardpan
hards96435652hard_s
hardset113415832hardset
hardy125622062hard_y
hare76255732har_e_
hared95742182har_ed
hareem114312062hareem
harem104924452har_em
hares86255542har_es
harked145422552harked
harkens144112862harkens
harmed125218832harmed
harmer114719552harmer
harmin113117392harmin
harped124418402harped
harper115018402harper
harpin113614382harpin
harshen1339282harshen
hasten95718562hasten
hausen9610382hausen
haven114718532ha_ven
hearken14338022hearken
hearten102411752hearten
herded114215642herded
herder104516462herder
herdmen13238452herdmen
hidden11429742hidden
hoarded12368342hoarded
hoarder11329232hoarder
hoarsen10367992hoarsen
hodden113811452hodden
hoiden103612332hoiden
holden104113952holden
horde94623052horde_
horded115420482horded
hordein1138752hordein
hordes104921632hordes
hoyden13328932hoyden
laden65022192la_den
larded84319092larded
larder73720972larder
lardon74415062lardon
madden103912522madden
maiden93512282maiden
marten84518262marten
pardee93922022pardee
pardon94618732pardon
reharden1276302reharden
sadden83212402sadden
sarsen6314232sarsen
sharpen12389722sharpen
warded115021042warded
wardens113711902wardens
warder104020272warder
warren95012852warren
yarded114714022yarded
yarder103813972yarder
yardmen1335422yardmen

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511002.97027794.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911003.36053181.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.