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

290 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
gored7522708(None) 
bored85034301bored
cored85044221cored
gore55744961gore_
gores65740371gores
gorged95016981gorged
gormed105013831gormed
gyred105114091gyred
pored85234511pored
sored66141781sored
acred87126352acred
adored84714232adored
aired66032922aired
bared85144482bared
boded95124962boded
boned85133242boned
booed85127272booed
bore66051332bore_
borer75131272borer
bores76448252bores
borked135117292borked
bowed114533422bowed
boxed154318612boxed
bred75130972_bred
cared86050092cared
cered85227442cered
chored125321882chored
coded95433182coded
coed77140542co_ed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cord76740922cor_d
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
cred76530882_cred
cured85932132cured
dared75935012dared
doled75430912doled
domed95423262domed
doped95326712doped
dore56353302dore_
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
dured75025402dured
eared65139502eared
erred65915672erred
fared95842342fared
fired94829742fired
forced126316522forced
ford86835492for_d
forded115020392forded
fore78351472fore_
foredo10510822foredo
fores85847102fores
forged115519322forged
forked145217142forked
formed125021172formed
foxed165115212foxed
gaed66031512g_aed
gaged85522312gaged
gamed95126392gamed
gaoled84814492gaoled
gaped96123532gaped
garbed104815662garbed
garred85217402garred
gated75329772gated
gazed165520332gazed
geared85317742geared
ged57044532g__ed
geed65435502g_eed
gibed96215962gibed
gied64631982g_ied
gird65424992gir_d
girded93712492girded
girned84010512girned
girted83912872girted
glared84715192glared
gled65631142g_led
gleed75320572gleed
globed104811762globed
gloried9169512gloried
gloved114811872gloved
glowed114913832glowed
glozed173711222glozed
glued75118362glued
goad66830982go_ad
goaded94913712goaded
goaled85014352goaled
gobbed124613882gobbed
god57449792go__d
godded104811802godded
godet7530042godet
goer56827102go_er
goers65520252goers
goes55644092go_es
gofer94814282gofer
gold65430162go_ld
golem8416112golem
golfed11569762golfed
gomer85220652gomer
gonad75216052gonad
gone55639042gone_
gonef95221292gonef
goner66025162goner
gonged97115912gonged
good66531802go_od
gooey95522862gooey
goofed114911382goofed
goosed86817032goosed
gor47848262gor__
goral65125752goral
gorge76423892gorge
gorger86116982gorger
gorges85321892gorges
gorget87123862gorget
gorhen1038892gorhen
gorier73719372gorier
gorm75529392gor_m
gorms85619592gorms
gorp75625902gor_p
gorps85316992gorps
gorse65926812gorse
gorses74723292gorses
gorsy95915782gorsy
gory86129662gor_y
gouged96214592gouged
gourd71011902gourd
gourde8107932gourde
gowd96519982go_wd
gowned114410132gowned
goxes135018262goxes
grad66829862g_rad
gree56641562g_ree
greed75125692greed
grew85620262g_rew
grey85624042g_rey
grid65829612g_rid
groped107515052groped
groved114413702groved
gurged95513362gurged
guyed1049892guyed
gybed125811022gybed
gyre84722762gyre_
gyres94820322gyres
gyved13568742gyved
hared95742182hared
hired95226262hired
hoed87837982ho_ed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hoped115628182hoped
horde94623052horde
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982hosed
ignored9226442ignored
ired55131872_ired
joked175217912joked
jowed164724422jowed
joyed164811832joyed
kore85834162kore_
lobed86022132lobed
looed64626132looed
loped85128332loped
lord55032082lor_d
lorded84916732lorded
lore45850352lore_
lores55045402lores
loured74617402loured
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lured65427492lured
mired85729222mired
mooed85123982mooed
moored93814172moored
moped105424732moped
more67154522more_
morel75729092morel
mores76249642mores
moved114218152moved
mowed113629012mowed
mured85726702mured
normed95014542normed
nosed65524552nosed
noted65123842noted
oared65030652oared
odored8399222odored
ogled75915962ogled
ogre56320742ogre_
ogres65818632ogres
ohed87825182_ohed
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
orad56031692_orad
orbed85516192_orbed
ore36661832_ore_
oread64619602_oread
ores46056682_ores
owed86833872_owed
pared86946762pared
poked125425392poked
poled84934842poled
pooed85226242pooed
pore66451262pore_
pores75849032pores
porked134717622porked
ported94223242ported
posed85828412posed
poured95116742poured
poxed154817862poxed
rared65738322rared
red46755802__red
roared75015392roared
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
scored94621132scored
sered65737292sered
shored105723642shored
shred98125612shred
sired66134282sired
snored74819542snored
soared74324292soared
soled65835172soled
sorbed94916512sorbed
sord56237202sor_d
sore47059532sore_
sorel56231442sorel
sorer56236572sorer
sores55454282sores
sorned74820042sorned
sorted74523712sorted
soured74921862soured
sowed94933862sowed
spored94821792spored
stored75524212stored
tared69340052tared
tired65228902tired
toed56137042to_ed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
tore47359322tore_
tores55352672tores
toted64929482toted
toured74216152toured
towed95134582towed
toyed96019802toyed
tyred95816432tyred
voled95323722voled
voted93919142voted
vowed124424572vowed
wared96339872wared
whored135512122whored
wired95327642wired
wooed94419872wooed
word89832002wor_d
worded114316622worded
wore77144672wore_
worked145314702worked
world96915362world
wormed124314302wormed
wowed124023772wowed
yoked134821622yoked
yore76335942yore_
yores85031322yores
yowed1253025182yowed
zoned154020262zoned

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.0961861364.6
2DLD Change Limit538002901.81029723.8
3Display Results2902900.0803625.0
 (SQL Overall)1786912901.98689975.3
 
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.