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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
heath11572428(None) 
death94822521death
eath75735661_eath
hath105933911h_ath
health124712141health
hearth125315211hearth
heat77061421heat_
heaths126316381heaths
heathy156111211heathy
heats85838401heats
heth107028021he_th
neath86020281neath
sheath12412891sheath
bath95940082_bath
beach124623892beach
beat66168302beat_
beats76042242beats
berth104917882berth
beth96629232be_th
breath113916262breath
cheat105732452cheat_
cheats114519542cheats
chetah14399582chetah
cheth135013822che_th
dearth104212512dearth
deash95617242deash
deaths105914442deaths
deathy134210232deathy
depth114311852depth
each95530582_each
earth85023052_earth
eat36989052_eat_
eats47054872_eats
eth66630982_e_th
feat76458222feat_
feats86432752feats
haet75659502haet_
haets86525122haets
hah910655222h_a_h
hash106936502h_ash
hat67289962h_at_
hatch135719592h_atch
hate78450172h_ate
hats76858252h_ats
head87137172hea_d
heads95127112heads
heady125117262heady
heal75645692hea_l
heals85733452heals
healths13478752healths
healthy16416082healthy
heap96432892hea_p
heaps105223222heaps
heapy135914982heapy
hear76143882hea_r
heard95222752heard
hears86737372hears
heart85440742heart
hearths135311072hearths
hearts96218942hearts
hearty126313632hearty
heated104525592heated
heater94828302heater
heathen133410892heathen
heather133914852heather
heave114521812heave
heavy144814182heavy
heft106736292heft_
hefts116218152hefts
hefty146112132hefty
heh96039622he__h
heigh124812542heigh
hent76656382hent_
hents87330742hents
hertz174919042hertz
hest75950772hest_
hests85829932hests
het67674312he_t_
heths116317782he_ths
hets75547202he_ts
heuch135312332heuch
heugh125410922heugh
kheth15509752khe_th
lath76640382_lath
leach105422522leach
leash85519212leash
loath84918602loath
math95437452_math
meat66359602meat_
meats75034052meats
meaty107021312meaty
meth95827842me_th
neat46356782neat_
neats55931902neats
oath76132152_oath
path99134912_path
peach125422492peach
peat65967932peat_
peats76140192peats
peaty105725692peaty
rath76037662_rath
reach105123882reach
reata54225392reata
seat47575562seat_
seats54844342seats
sheathe1348992sheathe
sheaths1358752sheaths
snath86419802snath
swath115920382swath
teach105221122teach
teat45963632teat_
teats55636812teats
teeth87315852teeth
tenth85421832tenth
teth76327892te_th
wealth12379222wealth
wheat114924572wheat_
wheats125013222wheats
wrath115715872wrath
wreath124111192wreath
yeah106725412yea_h

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001211.70331591.3
3Display Results1211210.0304033.3
 (SQL Overall)1786911212.04687336.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.