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

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

468 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
hearth12531521(None) 
dearth104212511dearth
earth85023051_earth
health124712141health
heart85440741heart_
hearths135311071hearths
hearts96218941hearts
hearty126313631hearty
heath115724281hea_th
berth104917882be_rth
dearths11498842dearths
death94822522dea_th
earths95014592_earths
earthy12399942_earthy
eath75735662_ea_th
garth94720222_garth
harsh116418052h_arsh
hart76865772h_art_
harts88441592h_arts
hath105933912h_a_th
healths13478752healths
healthy16416082healthy
hear76143882hear__
heard95222752hear_d
hearer94323642hearer
hears86737372hear_s
hearse94114272hearse
hearted113314022hearted
hearten102411752hearten
heat77061422hea_t_
heaths126316382hea_ths
heathy156111212hea_thy
heats85838402hea_ts
hertz174919042he_rtz
heth107028022he__th
inearth1037042inearth
neath86020282nea_th
peart76440752peart_
search113312422search
sheath12412892shea_th
swarth126012082swarth
unearth1037062unearth
wealth12379222wealth
aargh96314083_aargh
aerate64830553aerate
airth85621023_airth
anarch11310393anarch
apart74330673apart_
arch98628443__arch
art38679143__art_
arts49650263__arts
arty77531313__arty
baith108023133_baith
bath95940083_ba_th
beach124623893bea_ch
bear66844643bear__
beard86024963bear_d
beards94116673beards
bearer85323913bearer
bearish123013273bearish
bears75739043bear_s
beast76338643beast_
beasts84519723beasts
beat66168303bea_t_
beats76042243bea_ts
beaut75135213beaut_
beauts86015283beauts
beauty115410163beauty
berate84729023berate
bertha11429173be_rtha
berths114712423be_rths
beth96629233be__th
betroth1247543betroth
birth105619873_birth
boart78835933boart_
boarts84716873boarts
breadth1365993breadth
breath113916263brea_th
cart66570343_cart_
carte75940423_carte
carts78946293_carts
cerate84829463cerate
chart105038283chart_
charts115823093charts
cheat105732453chea_t_
cheats114519543chea_ts
chert105232103che_rt_
cherts115617233che_rts
cherty144612473che_rty
cheth135013823che__th
dart55857873_dart_
darts67635733_darts
dealt65234283dealt_
dear55343603dear__
dearer74822803dearer
dearie73319813dearie
dearly104615323dearly
dears65736883dear_s
deary95826843dear_y
deash95617243dea_sh
deaths105914443dea_ths
deathy134210233dea_thy
depart94720563depart_
departs104310683departs
depth114311853de_pth
derat65044083derat_
derate74531233derate
derats74625063derats
each95530583_ea_ch
ear36867883_ear__
eared65139503_eared
earl45838143_ear_l
earls56127513_earls
early85324123_early
earn46737553_ear_n
earns55927563_earns
ears46356593_ear_s
earthed1139923_earthed
earthen1039253_earthen
earthly13387383_earthly
east46659103_east_
easts57530323_easts
eat36989053_ea_t_
eats47054873_ea_ts
ecarte84313503ecarte
eparch13258423eparch
eth66630983_e__th
exarch18196173exarch
faith115620853_faith
fart76860563_fart_
farts88336843_farts
fealty122910223fealty
fear75337793fear__
feared106320433feared
fearer94820183fearer
fears84829393fear_s
feast85932723feast_
feasts95116093feasts
feat76458223fea_t_
feats86432753fea_ts
firth115819533_firth
forth116222673_forth
fourth12357443fourth
garths104111503_garths
gear55934973gear__
geared85317743geared
gears64628693gear_s
gerah9315303ge_rah
girth95618843_girth
haar77323493haar__
haars85620473haar_s
hadith13312063hadith
haeres94017033haeres
haet75659503h_aet_
haets86525123h_aets
haft105941843h_aft_
hafts116219463h_afts
hah910655223h_a__h
halt76056303h_alt_
halts85230103h_alts
hant75461593h_ant_
hants86335403h_ants
hard85443503h_ar_d
hards96435653h_ards
hardy125622063h_ardy
hare76255733h_ar_e
hared95742183h_ared
harem104924453h_arem
hares86255543h_ares
hark115237393h_ar_k
harks126333433h_arks
harl75740003h_ar_l
harls85634503h_arls
harm95637793h_ar_m
harms106829013h_arms
harp96134293h_ar_p
harps105926873h_arps
harpy136418213h_arpy
harry115322953h_arry
hartal9415473h_artal
hash106936503h_a_sh
hast76259483h_ast_
haste85927863h_aste
hasty115718763h_asty
hat67289963h_a_t_
hatch135719593h_atch
hate78450173h_a_te
hats76858253h_a_ts
haugh125114053h_augh
haut75949733h_aut_
haute89521613h_aute
havarti1345053havarti
head87137173hea__d
headed114020473headed
header104422543header
heads95127113hea_ds
heady125117263hea_dy
heal75645693hea__l
healed105121443healed
healer94221803healer
heals85733453hea_ls
heap96432893hea__p
heaped124516903heaped
heaper114119523heaper
heaps105223223hea_ps
heapy135914983hea_py
hearers104319783hearers
hearing113324163hearing
hearken14338023hearken
hearsay1335523hearsay
hearsed113811403hearsed
hearses104414533hearses
heartache1743703heartache
heartens113010153heartens
hearthrug1652703hearthrug
heartier1139093heartier
hearties11315413hearties
heartily1436563heartily
hearting12513123hearting
heated104525593heated
heater94828303heater
heathen133410893hea_then
heather133914853hea_ther
heaume1137543heaume
heave114521813hea_ve
heaved134717863heaved
heaven123912603heaven
heaver124819673heaver
heaves124120303heaves
heavy144814183hea_vy
heft106736293he_ft_
hefts116218153he_fts
hefty146112133he_fty
hegari1039523hegar_i
hegaris11310433hegaris
heh96039623he___h
heigh124812543he_igh
height134713433height
heighth13366343heighth
heir77523803heir__
heired103813043heired
heirs85618563heir_s
heist87030913heist_
heists96814633heists
helot85332683helot_
helots95217703helots
henry114014473henr_y
henrys12366103henrys
hent76656383he_nt_
hents87330743he_nts
heparin12410433heparin
heptarch1843563heptarch
her66547813he_r__
herald10311343herald
herb94730963he_r_b
herbs105520503he_rbs
herby134715313he_rby
herd84933063he_r_d
herds96424683he_rds
here76447103he_r_e
heres86245903he_res
hereto9313693hereto
herl75834553he_r_l
herls85226433he_rls
herm95636153he_r_m
herma105318883he_rma
herms105626433he_rms
hern76134893he_r_n
herns84825583he_rns
hero74635783he_r_o
heron85025503he_ron
heros84930863he_ros
herry114922473he_rry
hers75844873he_r_s
hest75950773he_st_
hests85829933he_sts
het67674313he__t_
heths116317783he__ths
hets75547203he__ts
heuch135312333he_uch
heugh125410923he_ugh
hexarchy2642873hexarchy
hierarch1644043hierarch
highth12389153highth
hijrah1934283hijrah
hoar76729163hoar__
hoard94918313hoar_d
hoards104912623hoards
hoars85925553hoar_s
hoarse94411323hoarse
hoary114516763hoar_y
hoorah124411113hoorah
horah117922053h_orah
hurrah12369183hurrah
hurt77142573h_urt_
hurts86922823h_urts
inarch1139173inarch
inearths1144933inearths
kart86750803_kart_
karts97630113_karts
kheth15509753khe__th
laith85722103_laith
larch105919793_larch
lath76640383_la_th
leach105422523lea_ch
lealty92910603lealty
leant56737783leant_
leapt75027473leapt_
lear47045953lear__
learn55322663lear_n
learns65513743learns
learnt64019253learnt
lears55938733lear_s
leary85927383lear_y
leash85519213lea_sh
least56134883least_
leasts64616413leasts
length1046103length
loath84918603loa_th
lyart85121883lyart_
march125622893_march
marsh105320853_marsh
mart66865983_mart_
marts77442233_marts
math95437453_ma_th
meant76537213meant_
meat66359603mea_t_
meats75034053mea_ts
meaty107021313mea_ty
merch125417963me_rch
mesarch1445533mesarch
meth95827843me__th
mirth106418893_mirth
near45236503near__
nearby11356053nearby
neared75119803neared
nearer64618893nearer
nearly94813733nearly
nears55529423near_s
neat46356783nea_t_
neats55931903nea_ts
nerts55924983ne_rts
nertz145117453ne_rtz
north86018273_north
oath76132153_oa_th
oxheart1746213oxheart_
oxhearts1842903oxhearts
parch125123003_parch
part65967463_part_
parts77743373_parts
party106630613_party
path99134913_pa_th
peach125422493pea_ch
pear69745233pear__
pearl75324463pear_l
pearls84715393pearls
pearly116414843pearly
pears75138613pear_s
pearter9412743pearter
peartly1267453peartly
peat65967933pea_t_
peats76140193pea_ts
peaty105725693pea_ty
perch124518833pe_rch
pert66759323pe_rt_
quart144027853quart_
quarte154115323quarte
quarto153511123quarto
quarts154715933quarts
quartz244212103quartz
rath76037663_ra_th
reach105123883rea_ch
react74634333react_
reacts83616603reacts
realty92713693realty
rear45644553rear__
reared75930013reared
rearer64928913rearer
rearm75923573rear_m
rearms85114653rearms
rears54739653rear_s
reata54225393rea_ta
rebirth1244933rebirth
saith85826553_saith
scarph13429603scarph
scart76139773scart_
scarts85321493scarts
sear47353843sear__
seared75232843seared
searer65432023searer
sears54744913sear_s
seat47575563sea_t_
seats54844343sea_ts
seraph114011163seraph
shear85424833shear__
sheared114516003sheared
shearer104414683shearer
shears93820903shear_s
sheathe1348993shea_the
sheaths1358753shea_ths
smart75834093smart_
smarts86218003smarts
smarty115013793smarty
snath86419803sna_th
starch113013203starch
start55642313start_
starts65423123starts
stealth1096453stealth
strath93216373strath
swart86234643swart_
swarths13537323swarths
swarthy16466373swarthy
swarty125812383swarty
swath115920383swa_th
tart47566183_tart_
tarts57242023_tarts
tarty86328183_tarty
teach105221123tea_ch
tear45242883tear__
teared75722153teared
tearer64822903tearer
tears55436463tear_s
teary85124053tear_y
teat45963633tea_t_
teats55636813tea_ts
teeth87315853te_eth
tenth85421833te_nth
teraph11319093teraph
teth76327893te__th
thearchy1943443thearchy
theatre10358493theatre
thwart12311683thwart_
thwarts1345023thwarts
unearths1144353unearths
vert77249373ve_rt_
verts85724733ve_rts
vertu85017613ve_rtu
warmth1477933_warmth
wart77866083_wart_
warts814840403_warts
warty119323823_warty
wealths13365813wealths
wealthy16314333wealthy
wear75836723wear__
wearer94319403wearer
wearish132310153wearish
wears86030303wear_s
weary115620613wear_y
wert79749823we_rt_
wheat114924573whea_t_
wheats125013223whea_ts
worth117120523_worth
wraith1258603wraith
wrath115715873wra_th
wreath124111193wrea_th
xerarch1943843xerarch
yeah106725413yea__h
year76534253year__
yearly125210273yearly
yearn86316433year_n
yearns9509543yearns
years84527673year_s
yeast85327943yeast_
yeasts96413053yeasts
yeasty12438693yeasty
yirth116513753_yirth
zenith1839073zenith
zeroth1837963zeroth

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 Filter1786911127160.406440125.6
2DLD Change Limit1127164686.04618643.1
3Display Results4684680.1403342.9
 (SQL Overall)1786914686.59227107.3
 
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.