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

433 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
hared9574218(None) 
bared85144481bared
cared86050091cared
chared125423691chared
dared75935011dared
eared65139501eared
fared95842341fared
haded105227621haded
haed86338581ha_ed
haired105117171haired
haled95335821haled
hard85443501har_d
hare76255731hare_
harem104924451harem
hares86255541hares
harked145422551harked
harmed125218841harmed
harped124418401harped
hated95734021hated
hatred104814331hatred
hawed126025421hawed
hayed125822011hayed
hazed185222201hazed
hired95226261hired
oared65030651oared
pared86946761pared
rared65738321rared
shared105829061shared
tared69340051tared
wared96339871wared
aahed917816442aahed
abed79734132_abed
aced79540882_aced
acred87126352acred
aged67334252_aged
ahed89536252_ahed
aired66032922aired
aped78538152_aped
arced88224162_arced
are37874572_are_
area45843402_area
ares45871022_ares
arid57642722_arid
armed86324442_armed
awed88436032_awed
axed128829612_axed
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725802barred
based85331582based
bated85935532bated
bayed115423022bayed
blared95018242blared
bored85034302bored
bred75130972_bred
caged95426362caged
caked126128622caked
caned85838092caned
caped104931802caped
card710245872car_d
carded105424902carded
care66968372care_
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
caried94528692caried
carked134024822carked
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412cased
caved116227562caved
cawed116627062cawed
cered85227442cered
chafed154813912chafed
chaired134211242chaired
chard116124742char_d
chare105231982chare_
chares115631802chares
charged144614022charged
charked174814012charked
charmed154714252charmed
charred134614492charred
charted135116852charted
chased125019292chased
chawed155214602chawed
chored125321882chored
cored85044222cored
cred76530882_cred
cured85932132cured
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dured75025402dured
earned74818332earned
eased65430402eased
eaved95924502eaved
erred65915672erred
faced117727652faced
faded105025242faded
faired105915772faired
faked135225482faked
famed115928342famed
farad95720682farad
farced125216532farced
fard85639062far_d
farded114518952farded
fare76354462fare_
farer86733142farer
fares85852872fares
farmed125117662farmed
farted105121782farted
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
feared106320432feared
fired94829742fired
flared105317602flared
gaed66031512ga_ed
gaged85522312gaged
gamed95126392gamed
gaped96123532gaped
garbed104815662garbed
garred85217412garred
gated75329772gated
gazed165520332gazed
geared85317742geared
glared84715202glared
gored75227082gored
gyred105114092gyred
hacek145411842hacek
hacked164923512hacked
had77658772ha__d
hade85440202hade_
hades96035112hades
hae67364002ha_e_
haem95730982ha_em
haen76229452ha_en
haeres94017032haeres
haes77651022ha_es
haet75659502ha_et
hafted134713832hafted
hagged124317702hagged
hailed104122742hailed
hajes155420942hajes
hake115637842hake_
hakes126034302hakes
hale76052832hale_
haler85033532haler
hales85449842hales
halid94424982halid
haloed104717602haloed
halted105019602halted
halved134813902halved
hame97043132hame_
hames106138702hames
hammed144116972hammed
hand86833712ha_nd
handed114919982handed
hanged114222402hanged
hanked144220602hanked
hanted104124312hanted
happed144820102happed
harden105718532harden
harder105022402harder
hards96435652hards
hardy125622062hardy
hareem114312062hareem
harems115513822harems
hark115237392har_k
harken135116342harken
harks126333432harks
harl75740002har_l
harls85634502harls
harm95637802har_m
harmer114719562harmer
harms106829022harms
harp96134292har_p
harper115018402harper
harps105926872harps
harpy136418212harpy
harried113815542harried
harry115322952harry
harsh116418052harsh
hart76865772har_t
harts88441592harts
hashed136021942hashed
hasped125014442hasped
hasted105125282hasted
hate78450172hate_
hater85034752hater
hates86742572hates
hatreds11307812hatreds
hatted104921512hatted
hauled104415212hauled
have106137072have_
haven114718532haven
haver115124462haver
havered144011452havered
haves116034872haves
hawked174712672hawked
hayer114620242hayer
hayey144812532hayey
haze164833392haze_
hazel176414812hazel
hazer174820232hazer
hazes174928322hazes
headed114020472headed
healed105121442healed
heaped124516902heaped
heard95222752hear_d
hearer94323652hearer
hearsed113811422hearsed
hearted113314032hearted
heated104525592heated
heaved134717862heaved
heed86437602h_eed
heired103813042heired
herbed123513452herbed
herd84933062her_d
herded114215642herded
here76447102here_
heres86245902heres
hewed125619432hewed
hexed165615762hexed
hided105222452hided
hied85434052h_ied
hiked135919202hiked
hire75538972hire_
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hived125217912hived
hoard94918312hoar_d
hoarded12368342hoarded
hoaxed17378872hoaxed
hoed87837982h_oed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hoped115628182hoped
horde94623052horde
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982hosed
hued86925852h_ued
hurled104617452hurled
hyped145313332hyped
ired55131872_ired
jaded144417032jaded
japed156217632japed
jarred144613252jarred
jawed165517372jawed
laced87132642laced
laded74232612laded
laired75216812laired
laked105731122laked
lamed85235292lamed
lard56742002lar_d
larded84319092larded
laree56036302laree
lares54852632lares
larked114519472larked
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
lured65427492lured
maced108528692maced
maned86634102maned
mare64759332mare_
mares76457632mares
marked133921622marked
marled95523172marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mired85729222mired
mured85726702mured
nacred95212502nacred
naked105320852naked
naled65525052naled
named85223062named
nard56634452nar_d
nares55544152nares
narked114116742narked
neared75119812neared
paced106931682paced
paged95926782paged
paired95017522paired
paled85538722paled
paned85437182paned
pard76441322par_d
pare66760842pare_
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922042parged
parked134425142parked
parled94626292parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
phased124011972phased
pored85234512pored
raced87635312raced
raged74829452raged
raked105831422raked
raped85334622raped
rare45348432rare_
rarer54731702rarer
rares55247442rares
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
reared75930012reared
red46755812__red
roared75015392roared
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
sawed95628402sawed
sayed96127142sayed
scared95227292scared
seared75232842seared
sered65737292sered
shaded114518872shaded
shaled105023952shaled
shamed125120212shamed
shaped125020102shaped
shard96125962shar_d
share86437082share_
sharer95025482sharer
shares95236412shares
sharked153613912sharked
sharped134112052sharped
shaved135118382shaved
shawed134817232shawed
sheared114516012sheared
shored105723652shored
shred98125612shred
sired66134282sired
snared74824552snared
soared74324292soared
sored66141782sored
spared95427492spared
stared75429872stared
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
thawed13458462thawed
tired65228902tired
tyred95816432tyred
vaned94622422vaned
varied104817862varied
varved134110602varved
waded106024752waded
waged104822782waged
waired106015832waired
waked135626752waked
waled94331002waled
waned95831782waned
ward86542252war_d
warded115021042warded
ware76254722ware_
wares88250582wares
warked144421212warked
warmed124516902warmed
warned104018912warned
warped124816412warped
warred104019852warred
warted104223232warted
waved125223582waved
waxed166018482waxed
whaled134612032whaled
wharfed1734422wharfed
whored135512122whored
wired95327642wired
yard85633252yar_d
yarded114714022yarded
yare75636942yare_
yarer84321572yarer
yarned105514022yarned
yawed126022452yawed

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.326548131.9
2DLD Change Limit538004331.65632487.9
3Display Results4334330.1263436.5
 (SQL Overall)1786914332.10884768.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.