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

196 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
poxed15481786(None) 
boxed154318611boxed
coxed154322811coxed
foxed165115211foxed
loxed135017051loxed
poked125425391poked
poled84934841poled
pooed85226241pooed
pored85234511pored
posed85828411posed
poxes145325721poxes
axed128829612_axed
boded95124962boded
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
boxer145016522boxer
boxes145625072boxes
coaxed165612512coaxed
coded95433182coded
coed77140542co_ed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cored85044222cored
coted85033852coted
coved115027372coved
cowed115637842cowed
coxes145430862coxes
coyed114623802coyed
doled75430912doled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
epoxied1734812epoxied
epoxyed2032292epoxyed
exed125420592_exed
faxed166220532faxed
fixed165416952fixed
foxes156321092foxes
gored75227082gored
goxes135018262goxes
hexed165615762hexed
hoaxed17378872hoaxed
hoed87837982ho_ed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hoped115628182hoped
hosed95830982hosed
joked175217912joked
jowed164724422jowed
joyed164811832joyed
lobed86022132lobed
looed64626132looed
loped85128332loped
loved95021362loved
lowed95233902lowed
loxes125227472loxes
maxed155821192maxed
mixed155717252mixed
mooed85123982mooed
moped105424732moped
moved114218152moved
mowed113629012mowed
nixed135714222nixed
nosed65524552nosed
noted65123842noted
ohed87825182_ohed
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
opted84914272opted
owed86833872_owed
oxen116218592_oxen
oxes116530722_oxes
oxid12815482_oxid
paced106931682paced
paged95926782paged
paled85538722paled
paned85437182paned
pared86946762pared
pated85237842pated
paved115525262paved
pawed115725612pawed
paxes144928422paxes
payed115925932payed
ped66751522p__ed
peed76239182p_eed
phoned124014552phoned
pied75035362p_ied
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
pixel143911902pixel
pixes144323172pixes
pled75231432p_led
plied85118592plied
plowed124213202plowed
ployed124310562ployed
pocked154818982pocked
pod66351482po__d
podded115012712podded
poem86225772po_em
poet65552902po_et
pogey116017892pogey
poind84217912poind
poised94918472poised
poke105335362poke_
poker115122882poker
pokes116133012pokes
pokey145318972pokey
pole65951302pole_
poler74431792poler
poles75351002poles
polled94022002polled
pome85636692pome_
pomes94833932pomes
ponced114314812ponced
pond75530492po_nd
ponded105218772ponded
pone65747532pone_
pones74547042pones
ponged105619352ponged
ponied94920702ponied
pood75934322po_od
poohed123912522poohed
pooled94619812pooled
pooped113915942pooped
pope85535612pope_
popes95933812popes
popped104117812popped
pore66451262pore_
pores75849032pores
porked134717622porked
ported94223242ported
pose66441732pose_
poser75128772poser
poses74642762poses
posted93722492posted
potted94624012potted
poufed12449712poufed
pound84417862pound
poured95116742poured
pouted94021392pouted
power105325952power
pox126140692pox__
poxier153812112poxier
poxy166820892pox_y
preed85128112preed
pried84426862pried
probed114114822probed
prosed94921092prosed
proved125016032proved
puked124716222puked
puled84926522puled
pyxes175911402pyxes
raxed135622662raxed
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
sexed136618542sexed
soled65835172soled
sored66141782sored
sowed94933862sowed
spoked134413892spoked
spored94821792spored
taxed135620292taxed
toed56137042to_ed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
toted64929482toted
towed95134582towed
toyed96019802toyed
vexed165713112vexed
voled95323722voled
voted93919142voted
vowed124424572vowed
waxed166018482waxed
wooed94419872wooed
wowed124023772wowed
yoked134821622yoked
yowed1253025182yowed
zoned154020262zoned

Search took 5 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.0931921408.6
2DLD Change Limit538001963.65614715.5
3Display Results1961960.0932107.5
 (SQL Overall)1786911963.84246509.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.