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

277 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
ohed8782518(None) 
ahed89536251ahed
hoed87837981hoed
oohed94214211oohed
oped76230151oped
owed86833871owed
shed86536151shed
aahed917816442aahed
abed79734132abed
aced79540882aced
ached119227832ached
aged67334252aged
ahead96817052ahead
ahem97225362ahem
aped78538152aped
ashed97829772ashed
awed88436032awed
axed128829612axed
bed67950622_bed
bled75729312bled
boded95124962boded
bohea105013732bohea
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
boxed154318612boxed
bred75130972bred
chad105525502chad
chef125125622chef
chew126622132chew
chez184519022chez
chid106626402chid
coded95433182coded
coed77140542coed
cohead123811122cohead
coked124730692coked
coled85540762coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cored85044222cored
coshed124217542coshed
coted85033852coted
coved115027372coved
cowed115637852cowed
coxed154322812coxed
coyed114623802coyed
cred76530882cred
cued76329562cued
deed65340902deed
died66137852died
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
dyed96720762dyed
eched116919222eched
ed38645182__ed
eked96718022eked
exed125420592exed
eyed86623232eyed
fed76548352_fed
feed84538902feed
fled85429772fled
foxed165115212foxed
gaed66031512gaed
ged57044532_ged
geed65435502geed
ghee85726112ghee
gied64631982gied
gled65631142gled
gored75227082gored
had77658762_had
haed86338582haed
he58151952_he_
head87137172_head
heed86437602heed
heh96039622_heh
held85330402_held
hem86148732_hem
hen67555272_hen
hep86644142_hep
her66547812_her
herd84933062_herd
hes66654202_hes
het67674312_het
hew97642722_hew
hex137436172_hex
hey96741062_hey
hid76248382_hid
hied85434042hied
hod76852462_hod
hoe67562722hoe_
hoer76533982hoer
hoes75755732hoes
hoked135326992hoked
hold86235062hold
holed95634132holed
homed115425422homed
honed95332262honed
hood85132332hood
hoped115628182hoped
hosed95830982hosed
hued86925852hued
iced78721892iced
ired55131872ired
jeed125428502jeed
joked175217912joked
joshed174610902joshed
jowed164724422jowed
joyed164811832joyed
kheda1346532kheda
khet116328622khet
led46254552_led
lied55838092lied
lobed86022132lobed
looed64626132looed
loped85128332loped
loved95021362loved
lowed95233902lowed
loxed135017052loxed
med66146742_med
meed74934702meed
mohel104914832mohel
mooed85123982mooed
moped105424732moped
moshed124517492moshed
moved114218152moved
mowed113629012mowed
need54934152need
nosed65524552nosed
noshed104413502noshed
noted65123842noted
oared65030652oared
obe56638642obe_
obes66036832obes
obey96521302obey
ocher104516102ocher
ochred12328002ochred
od39255242o__d
odd57725452o_dd
ode47446582ode_
odea56224572odea
odes57243242odes
oe28473062o_e_
oes35866192o_es
offed12359162offed
ogee57629882ogee
ogled75915962ogled
oh57447002oh__
ohia75719362ohia
ohm86523012oh_m
ohms95514032ohms
oho66534382oh_o
ohs66232312oh_s
oiled64429472oiled
oke75839482oke_
okeh114615322okeh
okes84936342okes
old47033462o_ld
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omen66828182omen
omer67028392omer
one37050912one_
ones46146532ones
oozed154214262oozed
ope56845242ope_
open66427002open
opes65942612opes
opted84914272opted
orad56031692orad
orbed85516192orbed
ore36661832ore_
oread64619602oread
ores46056682ores
ose38147342ose_
oses46641512oses
other84219102other
ouched124316932ouched
oud47439072o_ud
outed65429062outed
oven76624142oven
over77227342over
owe67041032owe_
owes75137102owes
owned95113232owned
oxen116218592oxen
oxes116530722oxes
oxid12815482oxid
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
ped66751522_ped
peed76239182peed
phew128417112phew
pied75035362pied
pled75231432pled
poked125425392poked
poled84934842poled
pooed85226242pooed
poohed123912522poohed
pored85234512pored
posed85828412posed
poxed154817862poxed
red46755802_red
reed55549622reed
rhea75017432rhea
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
rued55729792rued
seed55549482seed
shad86230912shad
she66837692she_
shea76031572shea
sheds96122702sheds
shend94719972shend
sherd96321152sherd
shes75734352shes
shew108030762shew
shied96125492shied
shod86225062shod
shoed95723012shoed
shred98125612shred
sled55334372sled
sned56026052sned
soled65835172soled
sored66141782sored
sowed94933862sowed
sped76031492sped
sued56537932sued
ted46446562_ted
teed55439262teed
the67436052the_
thee78039062thee
them97427042them
then78429692then
thew108226232thew
they107223752they
thud85613912thud
tied55535212tied
toed56137042toed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
toted64929482toted
towed95134582towed
toyed96019802toyed
used55722822used
vied86328632vied
voled95323722voled
voted93919142voted
vowed124424572vowed
wed75843622_wed
weed85637512weed
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
whid115418872whid
wooed94419872wooed
wowed124023772wowed
yoked134821622yoked
yowed1253025182yowed
zed135431172_zed
zoned154020262zoned

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298722770.92032469.6
3Display Results2772770.0803462.5
 (SQL Overall)1786912771.266141146.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.