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

359 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
hearten10241175(None) 
hearken14338021hearken
hearted113314021hearted
heartens113010151heartens
beaten84617062bea_ten
earthen1039252_earthen
eaten55323052_ea_ten
hapten115312982h_apten
harden105718532h_arden
harken135116342h_arken
hasten95718562h_asten
headmen13259512headmen
hearer94323642hear_er
hearkens15336692hearkens
hearse94114272hearse_
hearsed113811402hearsed
hearses104414532hearses
heart85440742heart__
heartened1347062heartened
heartener1256762heartener
hearth125315212heart_h
hearths135311072hearths
heartier1139092heartier
hearties11315412hearties
hearting12513122hearting
hearts96218942heart_s
hearty126313632heart_y
heated104525592hea_ted
heater94828302hea_ter
heathen133410892heathen
heaven123912602hea_ven
hoarsen10367992hoarsen
marten84518262_marten
neaten64214542nea_ten
pearter9412742pearter
smarten9348862smarten
wheaten1336402whea_ten
aerate64830553aerate_
aerated85322373aerated
aerates74627493aerates
arpen74418043__arpen
artel56122743__artel
barmen105418533_barmen
barren85317613_barren
bartend1038753_bartend
barter85525373_barter
batten85217123_batten
beadmen12299453beadmen
bearded114212133bearded
bearer85323913bear_er
beater84729393bea_ter
bedarken1544513bedarken
berate84729023berate_
berated104422133berated
berates94126873berates
careen84119493_careen
carmen104019343_carmen
carte75940423_carte_
carted98631443_carted
cartel85022533_cartel
carter84932273_carter
cartes86239473_cartes
carton84522663_carton
carven114716663_carven
cerate84829463cerate_
cerated103922473cerated
cerates95428253cerates
ceratin93020163ceratin
certes84623083ce_rtes
charted135116853charted
charter123918303charter
chasten124312403chasten
cheapen14407623chea_pen
cheated134416343chea_ted
cheater124816963chea_ter
chorten122811303chorten
coarsen93210323coarsen
darken114013443_darken
darted84620923_darted
darter75320363_darter
deaden83714323dea_den
deadmen11248573deadmen
deafen10389673dea_fen
dearer74822803dear_er
dearie73319813dearie_
dearies83526273dearies
dearth104212513deart_h
dearths11498843dearths
departed1238823departed
departee1139723departee
derate74531233derate_
derated93623503derated
derates84028893derates
dishearten1444333dishearten
eared65139503_ear_ed
earn46737553_ear__n
earned74818333_earned
earner63617223_earner
earth85023053_eart_h
earthed1139923_earthed
earthmen1346393_earthmen
earths95014593_earths
earthy12399943_earthy
easter65027983_easter
eastern74412533_eastern
eater54639843_ea_ter
ecarte84313503ecarte_
ecartes94212563ecartes
farted105121783_farted
fasten95114893_fasten
fatten94314903_fatten
feared106320433fear_ed
fearer94820183fear_er
feasted11310843feasted
feaster10812983feaster
feater95224053fea_ter
flatten10429653flatten
garden84215083_garden
garter74420513_garter
geared85317743gear_ed
germen9612313ge_rmen
greaten83610643grea_ten
haen76229453h_a__en
haeres94017033haer_es
hafted134713833h_afted
hafter124815883h_after
halted105019603h_alted
halter94420883h_alter
hanted104124313h_anted
happen134812193h_appen
haptene123810933h_aptene
haptens124511343h_aptens
hardens113815023h_ardens
harder105022403h_arder
hare76255733h_ar_e_
hared95742183h_ar_ed
hareem114312063h_areem
harem104924453h_ar_em
hares86255543h_ar_es
harked145422553h_arked
harkens144112863h_arkens
harmed125218833h_armed
harmer114719553h_armer
harmin113117393h_armin
harped124418403h_arped
harper115018403h_arper
harpin113614383h_arpin
harshen1339283h_arshen
hart76865773h_art__
hartal9415473h_artal
harts88441593h_art_s
haste85927863h_aste_
hasted105125283h_asted
hastens106214813h_astens
hastes95727073h_astes
hate78450173h_a_te_
hated95734023h_a_ted
hater85034753h_a_ter
hates86742573h_a_tes
hatred104814333h_atred
hatted104921513h_atted
hatter94724873h_atter
hausen9610383h_ausen
haute89521613h_aute_
haven114718533h_a_ven
headed114020473hea_ded
headend12398363hea_dend
header104422543hea_der
headier113212953headier
headman13229633headman
headpin1336003headpin
headset11312603headset
headsmen1465983headsmen
healed105121443hea_led
healer94221803hea_ler
health124712143healt_h
healths13478753healths
healthy16416083healthy
heaped124516903hea_ped
heaper114119523hea_per
hear76143883hear___
heard95222753hear__d
hearers104319783hearers
hearing113324163hearing
hearkened1744453hearkened
hearkener1644213hearkener
hears86737373hear__s
hearsay1335523hearsay
hearsing1239383hearsing
heartbeat1444633heartbeat
heartburn1451823heartburn
hearteners1346213hearteners
heartening1446733heartening
heartfelt1543263heartfelt
heartfree1543273heartfree
heartiest12311103heartiest
heartily1436563heartily
heartland1343653heartland
heartless1236393heartless
heat77061423hea_t__
heaters104225223hea_ters
heath115724283hea_t_h
heathens143210153heathens
heather133914853heather
heaths126316383hea_ths
heathy156111213hea_thy
heating114024323hea_ting
heats85838403hea_t_s
heaume1137543heaume_
heaumes1237423heaumes
heave114521813hea_ve_
heaved134717863hea_ved
heavens13439303hea_vens
heaver124819673hea_ver
heaves124120303hea_ves
heavier13429423heavier
heavies132713873heavies
hefted134911423he_fted
hefter124313923he_fter
hegumen1355463hegumen
heighten1545703heighten
heired103813043heir_ed
heisted113210653heisted
heister103613623heister
hematein1387013hematein
hematin121516023hematin
hempen1338963he_mpen
henries102718283henries
hented104218753he_nted
heparin12410433hepar_in
herbed123513453he_rbed
herded114215643he_rded
herder104516463he_rder
herdmen13238453herdmen
here76447103he_r_e_
herein93717793he_rein
hereon93914363he_reon
heres86245903he_r_es
hereto9313693he_reto
hern76134893he_r__n
heroes94923823he_roes
heroin94420593he_roin
heron85025503he_r_on
herpes115517323he_rpes
herried113514453herried
herries104025073herries
hertz174919043he_rt_z
hertzes1938303he_rtzes
hoarded12368343hoarded
hoarder11329233hoarder
hoarier104211743hoarier
hoarse94411323hoarse_
hoarsens11306023hoarsens
hoarser10388393hoarser
hurter93915853h_urter
keratin113314153keratin
laten54328343_la_ten
latten65018203_latten
leaden74515223lea_den
leadmen10277903leadmen
learier73415663learier
learn55322663lear__n
learned8329303learned
learner7319383learner
leaven95013073lea_ven
lenten6312883le_nten
marted94425213_marted
martens93714953_martens
martin84122523_martin
meated94222403mea_ted
meatmen1138243meatmen
mermen10813813me_rmen
neared75119803near_ed
nearer64618893near_er
neatens73310403nea_tens
neater64424313nea_ter
oaten55222403_oa_ten
partan83820563_partan
parted94228683_parted
parton84720993_parton
paten74827343_pa_ten
patten84418193_patten
peahen113410133pea_hen
pearled10411553pearled
pearler9310373pearler
peart76440753peart__
peartest10311303peartest
peartly1267453peartly
peasen84815963pea_sen
pecten102711103pe_cten
perter84422283pe_rter
platen84518203pla_ten
quartan1636423quartan
quarte154115323quarte_
quarter163211853quarter
quartern17286473quartern
quartes163314933quartes
quartet162814893quartet
ratten64217383_ratten
reacted103015713reacted
realter73716313realter
reared75930013rear_ed
rearer64928913rear_er
rearmed103912823rearmed
refasten1136103refasten
regreen8309043regreen
reharden1276303reharden
repartee10312753repartee
sarsen6314233_sarsen
scarted104816123scarted
seamen84518563sea_men
seared75232843sear_ed
searer65432023sear_er
seated75131063sea_ted
seater64534163sea_ter
sharpen12389723sharpen
sheared114516003shear_ed
shearer104414683shear_er
shorten103511413shorten
smarted105012613smarted
smartens10286663smartens
smarter94113133smarter
spartan948333spartan
spearmen1234853spearmen
started84217323started
starter73817883starter
tartan64217513_tartan
tarted74923373_tarted
tarter64023563_tarter
tauten64311893_tauten
teared75722153tear_ed
tearer64822903tear_er
tearier73815613tearier
teated74924023tea_ted
terreen7257573terreen
theater104014253thea_ter
theatre10358493theatre_
theatres11298633theatres
threaten1146303threa_ten
thwarted1533363thwarted
thwarter1433393thwarter
torten65314353_torten
uneaten7412543unea_ten
vertex1637373ve_rtex
warden104515513_warden
warren95012853_warren
warted104223233_warted
weaken13349603wea_ken
wearer94319403wear_er
wearied112911803wearied
wearier103613283wearier
wearies103020223wearies
wheatens1454663whea_tens
yearend11285703year_end
yearn86316433year__n
yearned11327373yearned
yearner10336873yearner
yeasted1138503yeasted
zeatin15412823zea_tin

Search took 9 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 Filter1786911340270.420425454.8
2DLD Change Limit1340273597.73617325.1
3Display Results3593590.1402564.3
 (SQL Overall)1786913598.29621539.4
 
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.