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

277 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
mixes14722440(None) 
fixes154723591fixes
maxes145629531maxes
mikes115129891mikes
miles74645071miles
mimes95732021mimes
mines75651951mines
minxes154612981minxes
mires75640881mires
mises74740561mises
mites75141801mites
mixed155717251mixed
mixer145017641mixer
mixers154513561mixers
nixes124519621nixes
pixes144323171pixes
sixes124526361sixes
admixes1765962admixes
aides65336602aides
amices105018012amices
amides95722662amides
amies76837692ami_es
amines84727982amines
axes117337852_axes
bemixes18338652bemixes
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
boxes145625072boxes
cines75239682cines
cires74932912cires
cites74435582cites
coxes145430862coxes
dexes135224512dexes
dices86434242dices
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
exes116530812_exes
faxes155726652faxes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixed165416952fixed
fixer154717832fixer
fixers165112982fixers
foxes156321092foxes
gibes84422522gibes
gies55641422gi_es
gites65630182gites
gives95324872gives
goxes135018262goxes
hexes155123042hexes
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hires86134342hires
hives116925512hives
ices66129642_ices
ides57734232_ides
imides94515342imides
imines84918352imines
immixes1835072immixes
ires45639282_ires
jibes145520322jibes
jinxes20428232jinxes
jives154820812jives
kexes166216812kexes
kibes115521112kibes
kikes85122552kikes
kines95039132kines
kites95432542kites
laxes125430092laxes
lexes127225262lexes
lies46454192li_es
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
loxes125227472loxes
luxes124921502luxes
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
mailes84329112mailes
maizes175115732maizes
makes115336852makes
males75049792males
manes76648952manes
mares76457632mares
mates75251362mates
maxed155821192maxed
maxis145721562maxis
maxixes1535252maxixes
mazes165632172mazes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mibs85330482mi_bs
micas96823052micas
mice87442232mice_
miches134320732miches
micks135525372micks
mics87435152mi_cs
midges103516472midges
midis85923412midis
mids76541782mi_ds
mien65028362mi_en
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mike105535292mike_
miked125020452miked
milds86422052milds
mile66352572mile_
miler75733062miler
milers84625162milers
milks115020582milks
milles84526562milles
mills75435052mills
milos75428012milos
mils66045332mi_ls
milts75430712milts
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimeos104511542mimeos
mimer94825762mimer
mimers105520182mimers
minas75434112minas
minces104420802minces
minds85427122minds
mine67256162mine_
mined85333352mined
miner76933542miner
miners84126632miners
minis75432992minis
minkes124618782minkes
minks115829272minks
mints76834042mints
minus75223932minus
mioses84318852mioses
mips85534082mi_ps
mire66748232mire_
mired85729222mired
mirex146816622mirex
mirexes1636992mirexes
mirks115122142mirks
mirs66940572mi_rs
mis58162622mi__s
mise66043582mise_
miser75430402miser
misers85025702misers
misos76523292misos
miss65339422mi_ss
misses85130872misses
mists76633902mists
mite66249412mite_
miter75734792miter
miters84328772miters
mitis75425992mitis
mitres83922072mitres
mitts75523752mitts
mix126138182mix__
mixt136831922mix_t
mixup1636772mixup
mixups1743262mixups
mizen164815272mizen
mizens174610252mizens
modes85537412modes
moires8915632moires
mokes114631032mokes
moles74747922moles
momes95134472momes
mopes95134982mopes
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
moxas145014392moxas
moxies154317402moxies
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
nides65229132nides
nines55937342nines
nites55736342nites
nixe115722022nixe_
nixed135714222nixed
nixies135313872nixies
oxes116530722_oxes
paxes144928422paxes
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixel143911902pixel
pixels15478532pixels
pixies154915512pixies
poxes145325722poxes
pyxes175911402pyxes
raxes124729392raxes
remixes164313872remixes
rexes124526952rexes
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
saxes125229342saxes
sexes126126222sexes
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixtes133612402sixtes
sizes146727762sizes
smiles84522292smiles
smites83921922smites
taxes124730822taxes
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
tuxes124316042tuxes
unmixes16197752unmixes
vexes155719122vexes
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vines85137642vines
vires84529682vires
vises84427772vises
vixen153010022vixen
vixens16286202vixens
waxes155825502waxes
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
yikes125117752yikes
yipes106017842yipes
zaxes215113822zaxes
zines145232652zines

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.0802233637.5
2DLD Change Limit538002771.37339184.3
3Display Results2772770.0803462.5
 (SQL Overall)1786912771.533116562.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.