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

430 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
heathy15611121(None) 
deathy134210231deathy
healthy16416081healthy
heath115724281heath_
heaths126316381heaths
apathy1437032apathy
beachy164011252beachy
breathy15328032breathy
death94822522death_
deathly14336862deathly
deaths105914442deaths
earthy12399942_earthy
eath75735662_eath_
featly123711752featly
hath105933912h_ath_
heady125117262hea_dy
health124712142health_
healths13478752healths
heapy135914982hea_py
hearth125315212hearth_
hearths135311072hearths
hearty126313632hearty
heat77061422heat__
heated104525592heated
heater94828302heater
heathen133410892heathen
heather133914852heather
heathery17349082heathery
heats85838402heat_s
heavy144814182hea_vy
hefty146112132heft_y
heth107028022he_th_
heths116317782he_ths
lathy115215062_lathy
leachy14419732leachy
meaty107021312meat_y
neath86020282neath_
neatly93812482neatly
peachy164510842peachy
peaty105725692peat_y
sheath12412882sheath_
sheathe1348982sheathe
sheaths1358742sheaths
wealthy16314332wealthy
wrathy15377852wrathy
wreathy16326062wreathy
achy126316093__achy
ashy107717353__ashy
bath95940083_bath_
bathe105822883_bathe
baths105922923_baths
batty105422243_batty
beach124623893beach_
beady114719923bea_dy
beaky146118023bea_ky
beamy126218573bea_my
beastly1277563beastly
beat66168303beat__
beaten84617063beaten
beater84729393beater
beatify1536593beatify
beats76042243beat_s
beauty115410163beauty
beechy16397503beechy
berth104917883berth_
bertha11429173bertha
berths114712423berths
beth96629233be_th_
beths105519223be_ths
bothy136713963_bothy
brashy145210593brashy
bratty1159683bratty
breath113916263breath_
breathe123711843breathe
breaths124411183breaths
brothy14519623brothy
catchy16559583_catchy
catty104520413_catty
chatty14419363chatty
cheaply1735023cheaply
cheat105732453cheat__
cheated134416343cheated
cheater124816953cheater
cheats114519543cheat_s
cherty144612473chert_y
chesty144610503chest_y
chetah14399583chetah_
chetahs15347073chetahs
cheth135013823che_th_
cheths14389823che_ths
dashy125612383_dashy
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
dearth104212513dearth_
dearths11498843dearths
deary95826843dea_ry
deash95617243deash_
deftly1336533deftly
deity94316773deit_y
depth114311853depth_
depths12428573depths
each95530583_each_
early85324123_early
earth85023053_earth_
earthly13387383_earthly
earths95014593_earths
easy76224493_ea_sy
eat36989053_eat__
eaten55323053_eaten
eater54639843_eater
eatery95316353_eatery
eats47054873_eat_s
empathy1743483empathy
entry82414263_entry
eth66630983_e_th_
eths76619523_e_ths
ethyl1136513_e_thyl
fatly115716803_fatly
fatty115117413_fatty
fealty122910223fealty
feat76458223feat__
feater95224053feater
feather133613503feather
feathery17368073feathery
feats86432753feat_s
filthy15356423filthy
flashy15498173flashy
flatly123110213flatly
frothy15578373frothy
gently103710913gently
gentry103410443gentry
gnatty10336483gnatty
greatly1137613greatly
haet75659503haet__
haets86525123haet_s
hah910655223h_a_h_
haha107821063h_a_ha
hahs108333363h_a_hs
hairy115316833h_airy
hammy155113433h_ammy
handy125520873h_andy
hanky155418293h_anky
haply135915063h_aply
happy155813533h_appy
hardy125622063h_ardy
harpy136418203h_arpy
harry115322953h_arry
hash106936503h_ash_
hasty115718763h_asty
hat67289963h_at__
hatch135719593h_atch
hate78450173h_at_e
hated95734023h_ated
hater85034753h_ater
hates86742573h_ates
hats76858253h_at_s
hay97358773h_a__y
hayey144812533h_ayey
hazy1918119193h_a_zy
head87137173hea__d
headachy2043313headachy
headed114020473headed
header104422543header
headily1478623headily
heads95127113hea_ds
headstay1543903headstay
headway1745553headway
heal75645693hea__l
healed105121443healed
healer94221803healer
heals85733453hea_ls
healthily1843103healthily
heap96432893hea__p
heaped124516903heaped
heaper114119523heaper
heaps105223223hea_ps
hear76143883hea__r
heard95222753hea_rd
hearer94323643hearer
hears86737373hea_rs
hearsay1335523hearsay
hearse94114273hearse
heart85440743hea_rt
hearted113314023hearted
hearten102411753hearten
heartily1436563heartily
hearts96218943hearts
heatedly1546043heatedly
heaters104225213heaters
heathenry1843403heathenry
heathens143210153heathens
heathers143914733heathers
heathier1438343heathier
heating114024323heating
heaume1137543heaume
heave114521813hea_ve
heaved134717863heaved
heaven123912603heaven
heaver124819673heaver
heaves124120303heaves
heavily1665903heavily
hectic132311513hectic
hector113312653hector
hedgy134510743he_dgy
heft106736293heft__
hefted134911423hefted
hefter124313923hefter
heftily1635763heftily
hefts116218153heft_s
heh96039623he__h_
hehs106723963he__hs
heigh124812543heigh_
height134713433height
heishi1235843heishi
helotry1345653helotry
hematal1238953hematal
hematic141816733hematic
hematin121516013hematin
hempy154912763he_mpy
henley1237483henley
henry114014473he_nry
hent76656383hent__
hented104218753hented
hents87330743hent_s
hepatic141712773hepatic
heptad1237273heptad
herby134715313he_rby
hereby14468333hereby
heresy125011233heresy
herry114922473he_rry
hertz174919033hert_z
hest75950773hest__
hests85829933hest_s
het67674313he_t__
hets75547203he_t_s
heuch135312333heuch_
heuchs14447923heuchs
heugh125410923heugh_
heughs13516903heughs
hexarchy2642873hexarchy
hey96741063he___y
heyday1635143heyday
heydey1634633heydey
hiatal9310193hiatal
hiatus938223hiatus
hoagy124710473hoa_gy
hoary114516763hoa_ry
hooty115022433hoot_y
hostly124210863hostly
hotly115815473h_otly
jetty156212583je_tty
kheth15509753khe_th_
kheths16495973khe_ths
lath76640383_lath_
lathe85626713_lathe
lathi85417203_lathi
laths86022403_laths
leach105422523leach_
leady95618603lea_dy
leafy116316213lea_fy
leaky125217723lea_ky
leally94012613leally
lealty92910603lealty
leanly93811503leanly
leary85927383lea_ry
leash85519213leash_
leather103815783leather
leathery14438973leathery
leavy115715773lea_vy
lefty115613563left_y
lengthy1452733lengthy
lethe85717303le_the
loath84918603loath_
loathe94211383loathe
loathly1334713loathly
mashy136016503_mashy
matey107022663_matey
math95437443_math_
maths105624023_maths
mealy104422183mea_ly
meanly115412043meanly
meany104620473mea_ny
measly113610443measly
meat66359603meat__
meatal84114733meatal
meated94222403meated
meatily12311093meatily
meats75034053meat_s
meatus85112923meatus
meetly1138673meetly
melty104918363melt_y
meshy135612783me_shy
meth95827843me_th_
meths105320233me_ths
methyl1436403me_thyl
mothy136214553_mothy
mouthy14409063mouthy
mythy16568673_mythy
natty85719143_natty
nearby11356053nearby
nearly94813733nearly
neat46356783neat__
neaten64214543neaten
neater64424313neater
neats55931903neat_s
nettly9459453nettly
netty85816763ne_tty
oath76132153_oath_
oaths86117313_oaths
patchy16509573_patchy
path99134913_path_
paths105521383_paths
patly105020583_patly
patsy105717203_patsy
patty104723613_patty
paty95234563_pat_y
peach125422493peach_
peaky145718153pea_ky
pearly116414843pearly
peartly1267453peartly
peat65967933peat__
peats76140193peat_s
peavey14398793peavey
peavy135014843pea_vy
peltry11288653peltry
pertly115312543pertly
pesty106421713pest_y
petty105320293pe_tty
phratry1543743phratry
pithy135614463_pithy
plashy14448873plashy
platy105021663plat_y
poachy16388963poachy
preachy17307313preachy
rath76037663_rath_
rathe85821923_rathe
ratty84819593_ratty
reach105123883reach_
ready94821503rea_dy
really93315613really
realty92713693realty
reata54225393reat_a
reatas64021013reatas
reechy14367823reechy
retry84718083re_try
satay84718463_satay
scathe114414993scathe
scatty115310653scatty
seamy105921273sea_my
seat47575563seat__
seated75131053seated
seater64534153seater
seats54844343seat_s
seaway12309993seaway
seethe93712483seethe
sentry92912053sentry
sheathed1547213sheathed
sheather1458213sheather
sheathes14610183sheathes
shelty124011543shelt_y
slatey95417063slatey
slaty86523153slat_y
smithy14508273smithy
snatchy15355293snatchy
snath86419803snath_
snathe94415113snathe
snaths95112913snaths
spathe115115693spathe
stealthy14103063stealthy
stithy12398213stithy
swarthy16466373swarthy
swath115920383swath_
swathe125514113swathe
swaths125312643swaths
sweaty123710053sweat_y
tatty84720183_tatty
teach105221123teach_
teapoy1138113teapoy
teary85124053tea_ry
teat45963633teat__
teated74924023teated
teats55636813teat_s
techy135612013te_chy
teeth87315853teeth_
teethe94511313teethe
tenth85421833tenth_
tenthly1335743tenthly
tenths94412663tenths
tenty86121603tent_y
testy85419063test_y
tetany959843tetany
tetchy1436003tetchy
teth76327883te_th_
teths85418513te_ths
thatchy1833303thatchy
thearchy1943443thearchy
theater104014253theater
theatre10358493theatre
thy97022913___thy
toothy12529693toothy
trashy12509053trashy
treaty94414353treat_y
unhealthy1841943unhealthy
vealy115817773vea_ly
vestry1238623vestry
washy145911843_washy
weakly1636483weakly
wealth12379223wealth_
wealths13365813wealths
weary115620613wea_ry
weather133513223weather
wetly114511713we_tly
wheat114924573wheat__
wheaten1336403wheaten
wheats125013223wheat_s
withy144813763_withy
worthy15598803worthy
wrath115715873wrath_
wraths123810083wraths
wreath124111193wreath_
wreathe13339053wreathe
wreaths13338373wreaths
yeah106725413yea_h_
yeahs115214553yea_hs
yearly125210273yearly
yeasty12438693yeasty
yechy16519083ye_chy
zeatin15412823zeatin
zesty176512163zest_y

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.1401276364.3
2DLD Change Limit1127164305.71619719.4
3Display Results4304300.1263412.7
 (SQL Overall)1786914305.98229871.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.