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

218 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
dyed9672076(None) 
deed65340901deed
died66137851died
dyad96415451dyad
dye75334841dye_
dyer85522111dyer
dyes85331891dyes
dyked145310951dyked
eyed86623231eyed
abed79734132abed
aced79540882aced
added84918432added
adzed166012542adzed
aged67334252aged
ahed89536252ahed
aped78538152aped
awed88436032awed
axed128829612axed
aye67151762aye_
ayes76543512ayes
bayed115423022bayed
bed67950622_bed
bled75729312bled
bred75130972bred
bye86134592bye_
byes95230532byes
coed77140542coed
coyed114623802coyed
cred76530882cred
cued76329562cued
dad58456162d_ad
dared75935012dared
dated75530992dated
dawed106222812dawed
daybed13438672daybed
dazed165919362dazed
de37049542d_e_
dead65434242dead
deb66342692d_eb
dee47665822d_ee
deeds75423762deeds
deedy104315892deedy
deem75432892deem
deep76031882deep
deer56739022deer
dees56356632dees
deet57356582deet
def76546722d_ef
deked115718532deked
del46752752d_el
deled75326542deled
den47554342d_en
dev76033772d_ev
dew77139922d_ew
dewed105020302dewed
dex116936882d_ex
dey77243372d_ey
deys85027472deys
diced95824682diced
did56850512d_id
die46759652die_
diel59034602diel
dies55653522dies
diet57357532diet
diked115024682diked
dined76431992dined
dived106321372dived
doe47361952doe_
doer57734702doer
does56554472does
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
doyen95014412doyen
dozed165619352dozed
drayed115911392drayed
dread74419022dread
dree56638322dree
dreed75222842dreed
dreg66821652dreg
drek96321082drek
drew86221672drew
dried75321382dried
dryad10477582dryad
dryer95111462dryer
duad66521412duad
dud56737592d_ud
dude65629662dude
duded84417132duded
due45249862due_
duel56729702duel
dues56045502dues
duet56446262duet
duked115218462duked
duped95118322duped
dured75025402dured
dyads10549972dyads
dyers96617132dyers
dyke126418182dyke
dykes135215572dykes
dykey16608672dykey
dyne85320932dyne
dynel9569852dynel
dynes95917582dynes
ed38645182__ed
edged85514512edged
eked96718022eked
exed125420592exed
eye65539772eye_
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
fayed126422152fayed
fed76548352_fed
feed84538902feed
fled85429772fled
gaed66031512gaed
ged57044532_ged
geed65435502geed
gied64631982gied
gled65631142gled
guyed1049892guyed
gybed125811022gybed
gyred105114092gyred
gyved13568742gyved
haed86338582haed
hayed125822012hayed
heed86437602heed
hied85434042hied
hoed87837982hoed
hued86925852hued
hyped145313332hyped
iced78721892iced
idled74915212idled
ired55131872ired
jeed125428502jeed
joyed164811832joyed
keyed1369382keyed
kye107327272kye_
kyes115124932kyes
layed95127382layed
led46254552_led
lied55838092lied
lye66533412lye_
lyes75530832lyes
lysed95011562lysed
mayed115522402mayed
med66146742_med
meed74934702meed
need54934152need
ohed87825182ohed
oped76230152oped
owed86833872owed
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
payed115925932payed
ped66751522_ped
peed76239182peed
pied75035362pied
pled75231432pled
pye86432502pye_
pyes95528992pyes
rayed95127502rayed
red46755802_red
redyed114611232redyed
reed55549622reed
rued55729792rued
rye66032542rye_
ryes75529352ryes
ryked13669512ryked
rynd86414102rynd
sayed96127142sayed
seed55549482seed
shed86536152shed
skyed13529922skyed
sled55334372sled
sned56026052sned
sped76031492sped
styed95815482styed
sued56537932sued
ted46446562_ted
teed55439262teed
tied55535212tied
toed56137042toed
toyed96019802toyed
tye65837442tye_
tyee75131422tyee
tyer75323392tyer
tyes76433372tyes
tyned95915012tyned
typed115815452typed
tyred95816432tyred
undyed1138142undyed
used55722822used
vied86328632vied
wed75843622_wed
weed85637512weed
wye96331972wye_
wyes105727502wyes
wyled124611842wyled
wynd116114462wynd
wyted12529472wyted
ye57650062_ye_
yea66445752_yea
yeh97135772_yeh
yeld811423872_yeld
yen66847382_yen
yep86638962_yep
yes66250612_yes
yet66960692_yet
yew96436292_yew
yid76640822_yid
yod77545502_yod
zed135431172_zed

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.0931921408.6
2DLD Change Limit298722180.84335435.3
3Display Results2182180.0633460.3
 (SQL Overall)1786912180.999178869.9
 
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.