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 “poxes” 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
poxes14532572(None) 
boxes145625071boxes
coxes145430861coxes
foxes156321091foxes
goxes135018261goxes
loxes125227471loxes
oxes116530721_oxes
paxes144928421paxes
pixes144323171pixes
pokes116133011pokes
poles75351001poles
pomes94833931pomes
pones74547041pones
popes95933811popes
pores75849031pores
poses74642761poses
poxed154817861poxed
pyxes175911401pyxes
apexes1539132apexes
axes117337852_axes
bodes84935102bodes
boles75448602boles
bones76446532bones
bores76448252bores
boxed154318612boxed
boxer145016522boxer
boxers155013482boxers
coaxes154715632coaxes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
coxed154322812coxed
cozes166033242cozes
dexes135224512dexes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
doxies143917852doxies
dozes155226302dozes
epodes94315562epodes
eposes84418782eposes
epoxies1637752epoxies
exes116530812_exes
faxes155726652faxes
fixes154723592fixes
foes76543442fo_es
fores85847102fores
foxed165115212foxed
goes55644092go_es
gores65740372gores
hexes155123042hexes
hoaxes163611692hoaxes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howes114730262howes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
kexes166216812kexes
laxes125430092laxes
lexes127225262lexes
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
loves85332012loves
lowes85732462lowes
loxed135017052loxed
luxes124921502luxes
maxes145629532maxes
mixes147224402mixes
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
moxas145014392moxas
moxies154317402moxies
nixes124519622nixes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxen116218592_oxen
oyes74940132_oyes
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
pases75346502pases
pates76047892pates
paves104833922paves
pedes85327282pedes
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penes75839222penes
peones83821042peones
peres76246642peres
pes57259782p__es
phloxes1935512phloxes
phones114121212phones
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixel143911902pixel
pixels15478532pixels
pixies154915512pixies
plexes155313532plexes
plies74526512plies
pocks135022962pocks
pods76540152po_ds
poem86225772po_em
poems95715552poems
poesy105014062po_esy
poet65552902po_et
poets76024442poets
pogey116017892pogey
pogeys124110352pogeys
pogies94123542pogies
pois66539042po_is
poise75127892poise
poises84226542poises
poke105335362poke_
poked125425392poked
poker115122882poker
pokers124617922pokers
pokey145318972pokey
pokeys15529512pokeys
pokies125921332pokies
pole65951302pole_
poled84934842poled
poleis86018352poleis
poler74431792poler
polers84225642polers
polies84034582polies
polis74731162polis
polls74627722polls
polos76129902polos
pols66044562po_ls
polys105718752polys
pome85636692pome_
pomos95321572pomos
pomps115316192pomps
poms87037742po_ms
ponces104720842ponces
ponds85323402ponds
pone65747532pone_
pongs85526342pongs
ponies84833462ponies
pons65850602po_ns
pontes83627852pontes
poods85124752poods
pooed85226242pooed
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430962poons
poops94422412poops
poos65949112po_os
pooves113914712pooves
pope85535612pope_
pops86340952po_ps
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
pose66441732pose_
posed85828412posed
poser75128772poser
posers84223972posers
posies84431432posies
posse74722272posse
posses85128802posses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
pours74623182pours
pouts75530322pouts
power105325952power
powers113822322powers
pows95537662po_ws
pox126140692pox__
poxier153812112poxier
poxiest163412252poxiest
poxy166820892pox_y
praxes156215182praxes
prees75937172prees
prexes154915942prexes
pries74339532pries
probes104119452probes
proles84627202proles
proses84733472proses
proves114322252proves
proxies163014932proxies
ptoses83514672ptoses
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
puses75532202puses
pyes95528992p_yes
pyoses114314302pyoses
pyres105523882pyres
pyxies18338292pyxies
pyxis17458632pyxis
raxes124729392raxes
rexes124526952rexes
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
saxes125229342saxes
sexes126126222sexes
sixes124526362sixes
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
taxes124730822taxes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
tuxes124316042tuxes
vexes155719122vexes
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
waxes155825502waxes
woes76440662wo_es
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zaxes215113822zaxes
zones145528042zones

Search took 8 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.356501941.0
2DLD Change Limit538002905.6909455.2
3Display Results2902900.1701705.9
 (SQL Overall)1786912906.21628746.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.