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

477 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
hatreds1130781(None) 
hatred104814331hatred_
haeredes1246332haeredes
haeres94017032haere_s
haired105117172haired_
hards96435652ha_r_ds
hared95742182ha_red_
harems115513822ha_rems
hares86255542ha_re_s
hated95734022hat_ed_
haters94930402hat_ers
hates86742572hat_e_s
hatless103813442hatless
hatted104921512hatted_
hatters104221522hatters
hotbeds13315002hotbeds
hotrods1148282hotrods
matres84522232matre_s
acred87126353_acred_
acres76327763_acre_s
actress948533actress
agrees74915323_agrees
aired66032923_aired_
airers64922313_airers
antres65021003antre_s
apres75426403_apre_s
areas55935773_a_reas
ares45871023_a_re_s
artels66216233_artels
ates45047923_at_e_s
attends8257593_attends
aures55137093_aure_s
aureus65314883_aureus
bardes95026933ba_rdes
bards87139643ba_r_ds
bared85144483ba_red_
bares75457133ba_re_s
barred95725803barred_
barrels94514363barrels
barrens94414323barrens
barres84427553barre_s
barrets94917103barrets
bartends1136793bartends
barters94223033barters
bated85935533bat_ed_
bates75846343bat_e_s
bathed125518743bathed_
bathers124720363bathers
bathes116524833bathe_s
batted95623653batted_
battens95313263battens
batters94626013batters
cadres94017933cadre_s
cairds96411513cair_ds
cards85137933ca_r_ds
cared86050093ca_red_
carers85133963ca_rers
cares77369183ca_re_s
caress85720263ca_ress
carets85330773ca_rets
carrels95117303carrels
carted98631443carted_
cartels94618123cartels
carters95327253carters
cartes86239473carte_s
catered103117773catered_
caterers102814403caterers
cateress102311613cateress
caters85336503cat_ers
cates75951893cat_e_s
catheads1438123catheads
catted95422473catted_
chaired134211243chaired_
chards125119733cha_r_ds
chared125423693cha_red_
chares115631803cha_re_s
charred134614493charred_
charted135116853charted_
charters134115583charters
chatted133411893chatted_
chattels13286793chattels
chatters134213953chatters
chytrids1744223chytrids
creds85418773__creds
dared75935013da_red_
darers75921873da_rers
dares66146703da_re_s
darted84620923darted_
darters84017603darters
dated75530993dat_ed_
daters74827373dat_ers
dates65639153dat_e_s
daybeds14234473daybeds
eagres74014573eagre_s
eared65139503ea_red_
eaters65535953eat_ers
entrees71813773entrees
faired105915773faired_
farads104713273fa_rads
fards96629843fa_r_ds
fared95842343fa_red_
farers95924053fa_rers
fares85852873fa_re_s
farted105121783farted_
fated95632133fat_ed_
fates85139233fat_e_s
fatheads1536763fatheads
fathers133916503fathers
fatless103212203fatless
fatness103311293fatness
fatted105419843fatted_
fattens105111713fattens
flatbeds14364543flatbeds
garred85217413garred_
garrets84413623garrets
garters84218233garters
gastreas957263gastreas
gated75329773gat_ed_
gaters74728643gat_ers
gates65939513gat_e_s
gathers114315073gathers
haars85620473haar__s
haceks15447863ha_ceks
hacked164923513hacked_
hackees165014103hackees
hackers164619043hackers
haded105227623ha_ded_
hades96035113ha_de_s
hadjees18356383hadjees
hadjes175210403hadje_s
hadrons113314303hadrons
haed86338583ha__ed_
haems105517013ha__ems
haes77651023ha__e_s
haets86525123ha__ets
haffets1636053haffets
hafted134713833hafted_
hafters134614333hafters
hagged124317703hagged_
hagride1237553hagride
hagrides1337623hagrides
hagrode1236453hagrode
hailed104122743hailed_
hailers104017263hailers
hairdo1036433hair_do
hairdos1136823hairdos
hairless1157413hairless
hairnets1195633hairnets
hairs86225173hair__s
hajes155420943ha_je_s
hajjes15485243hajje_s
hakeems16394803hakeems
hakes126034303ha_ke_s
halberds1435183halberds
haled95335823ha_led_
halers94926913ha_lers
hales85449843ha_le_s
halides113416663halides
halids104016133ha_lids
hallels103310133hallels
haloed104717603haloed_
haloes94623863haloe_s
haloids113012553haloids
halted105019603halted_
haltered123112563haltered_
halteres113414603halteres
halters104619803halters
haltless11308443haltless
halved134813903halved_
halvers133311423halvers
halves124717093halve_s
hames106138703ha_me_s
hamlets123211403hamlets
hammed144116973hammed_
hammers144216063hammers
hampers143616953hampers
hances115621283hance_s
handed114919983handed_
handers114224333handers
hands95327383ha__nds
hanged114222403hanged_
hangers113120813hangers
hanked144220603hanked_
hankers144218133hankers
hansels104011663hansels
hanses95022633hanse_s
hanted104124313hanted_
hantles104117513hantle_s
haoles94919803haole_s
hapless123311333hapless
happed144820103happed_
happens14359173happens
haptens124511343haptens
harass9313943ha_rass
hard85443503ha_r_d_
harden105718533ha_rden
hardens113815023hardens
harder105022403ha_rder
hardest113118413ha_rdest
hardy125622063ha_r_dy
hare76255733ha_re__
hareem114312063ha_reem
hareems12428203hareems
harem104924453ha_re_m
harked145422553harked_
harkens144112863harkens
harks126333433ha_r_ks
harls85634503ha_r_ls
harmed125218833harmed_
harmers124116593harmers
harms106829013ha_r_ms
harness102413933harness
harped124418403harped_
harpers124916203harpers
harps105926873ha_r_ps
harried113815543harried_
harriers113712433harriers
harries103525503harries
harrows132611043harrows
hartals10313023hartals
harts88441593ha_r_ts
hashed136021943hashed_
hashes125024803hashe_s
haslets102510863haslets
hasped125014443hasped_
hassels104311023hassels
hasted105125283hasted_
hastens106214813hastens
hastes95727073haste_s
hatbands1446293hatbands
hatched163414463hatched_
hatchels16368673hatchels
hatchers163113173hatchers
hatches153420273hatches
hatchets163310383hatchets
hate78450173hat_e__
hater85034753hat_e_r
hatfuls1386023hatfuls
hatpins123410643hatpins
hatrack1638213hatrack
hatracks1737533hatracks
hats76858253hat___s
hatter94724873hatte_r
hauled104415213hauled_
haulers104012443haulers
hausens1077633hausens
havens124514043ha_vens
havered144011453havered_
haverels14325753haverels
havers124721483ha_vers
haves116034873ha_ve_s
hawed126025423ha_wed_
hawked174712673hawked_
hawkers174210333hawkers
hawkeys20414703hawkeys
hawsers13409483hawsers
hawses125113993hawse_s
hayed125822013ha_yed_
hayers124415943ha_yers
hayride1437323hayride
hayrides1536883hayrides
hayseeds1543283hayseeds
hazards2037463hazards
hazed185222203ha_zed_
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_ze_s
hearers104319783hearers
hearted113314033hearted_
heartens113010153heartens
heated104525593heat_ed_
heaters104225223heat_ers
heathens143210153heathens
heathers143914733heathers
heatless113011463heatless
heeds95420423h__eeds
heired103813043heired_
heiress1036813heiress
herds96424683h_er_ds
heredes11313133h_eredes
heres86245903h_ere_s
heteros10312683heteros
hired95226263h_ired_
hirees95117293h_irees
hirers94518063h_irers
hires86134343h_ire_s
hitless103211193hitless
hitters104717593hitters
hoards104912623hoar_ds
hordes104921633h_ordes
hotbed123310683hotbed_
hotels94515523hot_els
hotheads15318023hotheads
hotness1038613hotness
hotpress1344303hotpress
hotrod1048803hotrod_
hotted104319943hotted_
hundreds1344003hundreds
huntress1144833huntress
hurds95219073h_ur_ds
hurters103413643hurters
hutted104616333hutted_
hybrids16236023hybrids
hydrids15267233hydrids
inbreds10245733inbreds
jarred144613253jarred_
labrets939363labrets
lairds74711613lair_ds
laired75216813laired_
lameds94812033la_meds
lards65331863la_r_ds
larees65323113la_rees
lares54852633la_re_s
lated65240673lat_ed_
lateens74210553lateens
latens64620213lat_ens
lathed104718463lathed_
lathers104321883lathers
lathes95127503lathe_s
latkes104715873latke_s
latrias71913213latrias
lattens75014673lattens
lattes65324203latte_s
laurels746663laurels
litres65220393litre_s
madres93718183madre_s
malteds10377603malteds
mares76457633ma_re_s
marred95421043marred_
marrers93414313marrers
marrieds11288073marrieds
marted94425213marted_
martens93714953martens
mated85537783mat_ed_
maters85032393mat_ers
mates75251363mat_e_s
mateys115610943mat_eys
matless93014043matless
matrass939403matrass
matrons93517633matrons
matted94521413matted_
matters94421753matters
mattes85624533matte_s
mattress1036533mattress
matured10310043matured_
maturers1037383maturers
matures9314313mature_s
metred95315143metred_
metres85121563metre_s
mitred94414343mitred_
mitres83922073mitre_s
nacred95212503nacred_
nacres85614453nacre_s
naleds7469133na_leds
nards65928463na_r_ds
nares55544153na_re_s
nates55238333nat_e_s
natrons73215663natrons
natters73718063natters
natured838963natured_
natures7311963nature_s
nitres65519333nitre_s
nitrids8269633nitrids
oared65030653oa_red_
oaters65029793oat_ers
oratress834553oratress
outreads9289003outreads
padres95016983padre_s
paired95017523paired_
pards85634333pa_r_ds
pared86946763pa_red_
pareos87023773pa_reos
parers85530743pa_rers
pares77164483pa_re_s
pareus85420743pa_reus
parred95024073parred_
parrels94713493parrels
parted94228683parted_
pated85237843pat_ed_
patens84820863pat_ens
paters84935833pat_ers
pates76047893pat_e_s
patness92912283patness
patrols93513513patrols
patrons93818103patrons
patted94724683patted_
pattens95414923pattens
patters94825193patters
patzers184210573patzers
petrels9279373petrels
quatres163411933quatre_s
ramrods1036583ramrods
rared65738323ra_red_
rares55247443ra_re_s
rated65441383rat_ed_
ratels64518213rat_els
raters63936583rat_ers
rates55352013rat_e_s
ratted74923343ratted_
rattens74213403rattens
ratters74422473ratters
reds56042863___reds
retreads937823retreads
sabred95916533sabred_
sabres85520863sabre_s
sacred94917103sacred_
sards64736183sa_r_ds
sarees65329943sa_rees
sarods74918573sa_rods
sated66238533sat_ed_
sateens73710753sateens
sates54949323sat_e_s
satires72617573satire_s
satraps95011643satraps
satyrids1245623satyrids
saurels749303saurels
sayeds10469253sa_yeds
shairds11216263shair_ds
shards104319173sha_r_ds
shared105829063sha_red_
sharers104720623sha_rers
shares95236413sha_re_s
shatters113313913shatters
shreds105613053_shreds
stared75429873stared_
starers74522313starers
stares66038753stare_s
starets73515923starets
steeds73814883_steeds
streps86218063_streps
stress66616673_stress
strews96817103_strews
tanrecs934823tanrecs
tared69340053ta_red_
tares57456563ta_re_s
tarred74720283tarred_
tarres64723043tarre_s
tarted74923373tarted_
taters64932203tat_ers
tates55444983tat_e_s
tatted74920533tatted_
tatters74520483tatters
teds54932573__t_eds
tetrads82910193tetrads
theatres11298643theatre_s
titres64718933titre_s
treads74817923__treads
trees55835763__trees
treks96016853__treks
trends75513543__trends
tres46542903__tre_s
tress55423163__tress
trets55928023__trets
trews86118893__trews
treys85018213__treys
untreads936223untreads
uptrends1142833uptrends
vatted104214733vatted_
votress1035483votress
waired106015833waired_
waitress1135223waitress
wards97734403wa_r_ds
wared96339873wa_red_
wares88250583wa_re_s
warred104019853warred_
warrens103810893warrens
warted104223233warted_
wastrels1136203wastrels
waterbeds1544883waterbeds
watered113014953watered_
waterers112312783waterers
waters95030633wat_ers
whatness1435093whatness
yairds10448023yair_ds
yards95324613ya_r_ds
yatters103914623yatters
zaires1539703zaire_s

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.436409841.7
2DLD Change Limit1340274777.50017870.3
3Display Results4774770.3131524.0
 (SQL Overall)1786914778.24921662.1
 
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.