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

289 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
boxes14562507(None) 
bodes84935101bodes
boles75448601boles
bones76446531bones
bores76448251bores
boxed154318611boxed
boxer145016521boxer
boxers155013481boxers
coxes145430861coxes
foxes156321091foxes
goxes135018261goxes
loxes125227471loxes
oxes116530721_oxes
poxes145325721poxes
abodes94417512abodes
aboves114512842aboves
axes117337852_axes
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
bees65453382b_ees
benes75536232benes
bes56557432b__es
beses75830722beses
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
biomes103815252biomes
bises75435622bises
bites75641172bites
bizes165923662bizes
blokes123813882blokes
blues75127042blues
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340652bo_bs
bocces123912022bocces
boches134618522boches
bocks134526572bocks
bode75838752bode_
boded95124962boded
bodies94524142bodies
bods76244712bo_ds
boffs134915502boffs
bogey115220232bogey
bogeys124510912bogeys
bogies94724312bogies
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
bohea105013732bohea
boheas114013212boheas
bohos105618252bohos
boils75427192boils
boites84322702boites
bolas74733762bolas
bolds85825282bolds
bole66448692bole_
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bombes124916822bombes
bombs115818822bombs
bonds86126842bonds
bone65949322bone_
boned85133242boned
boner75133082boner
boners84825432boners
boney105227312boney
bongs87828422bongs
bonks116326462bonks
bonnes85621452bonnes
bonus75324322bonus
bonzes175116102bonzes
boobs96221992boobs
booed85127272booed
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
boozes174916522boozes
bops86037982bo_ps
boras75938302boras
boraxes163511632boraxes
bore66051332bore_
boreas85421732boreas
bored85034302bored
borer75131272borer
borers85122682borers
borks115727702borks
borts76735452borts
bos57966812bo__s
boshes114721882boshes
bosks115218852bosks
boss65938342bo_ss
bosses85925402bosses
botas75328782botas
botel75121862botel
botels84815802botels
bots66453952bo_ts
botts75224862botts
boules84925972boules
bouse75931852bouse
bouses84931782bouses
bouts75131312bouts
bowed114533422bowed
bowel105621202bowel
bowels114315592bowels
bower107328182bower
bowers115523702bowers
bowls106121432bowls
bows96242862bo_ws
bowse105420632bowse
bowses115718862bowses
box1210142342box__
boxier154311742boxier
boxiest163711982boxiest
boxy166420732box_y
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
braes75735052braes
brees75632552brees
bries74942152bries
bromes104719762bromes
broses86524402broses
bruxes154811022bruxes
buses75936012buses
butes714535872butes
byes95230532b_yes
byres104421382byres
bytes105217492bytes
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
exes116530812_exes
faxes155726652faxes
fixes154723592fixes
foes76543442fo_es
fores85847102fores
foxed165115212foxed
goes55644092go_es
gores65740372gores
hexes155123042hexes
hoaxes163611692hoaxes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
howes114730262howes
ibexes15436162ibexes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
kexes166216822kexes
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
oboes75717712oboes
oboles83815832oboles
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxen116218592_oxen
oyes74940132_oyes
paxes144928422paxes
pixes144323172pixes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxed154817862poxed
pyxes175911402pyxes
raxes124729392raxes
rexes124526952rexes
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
saxes125229342saxes
sexes126126222sexes
sixes124526362sixes
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
taxes124730822taxes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
tuxes124316042tuxes
unboxes16208302unboxes
vexes155719122vexes
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
waxes155825502waxes
woes76440662wo_es
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zaxes215113822zaxes
zones145528042zones

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 Filter178691538000.326548131.9
2DLD Change Limit538002891.47036598.6
3Display Results2892890.0763802.6
 (SQL Overall)1786912891.87295454.6
 
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.