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 “mixups” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

237 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
mixups174326(None) 
mixup1636771mixup_
miauls8178712miauls
minus75223932minu_s
mips85534082mi__ps
mixers154513562mixers
mixes147224402mix_es
pinups1037412pinups
sirups83710532sirups
situps8538782situps
amicus103810003amicu_s
biceps12447713biceps
coups95522473_coups
croups104312553croups
cups85430823__cups
cutups1036813cutups
dips75536913di__ps
dixits144210313dixits
dups75929513__dups
ficus105015493ficu_s
fiques1837973fiques
fixers165112983fixers
fixes154723593fix_es
fixure16256543fixure
fixures17596063fixures
getups9346853getups
gigues8129003gigues
gimps105915203gi_mps
gips75632923gi__ps
groups94210513groups
hiccups1643223hiccups
hilus84817643hilu_s
hips96433703hi__ps
imaums10106303imaums
imbues1037983imbues
imps86221123_i_mps
ixias12488373_ixias
jaups144810533_jaups
kickups1443503kickups
kips106430523ki__ps
layups1133993layups
letups8317683letups
lieus56218483lieu_s
limps95522673li_mps
lineups934913lineups
linkups1333633linkups
linums838283linums
lips67141443li__ps
lisps76913913li_sps
loups75319623_loups
magus85318753magu_s
makeups1533603makeups
manus75924933manu_s
maps86141053m__aps
maquis17249483maquis
markups1534963markups
mauds85519273m_auds
mauls76524953m_auls
mauts75927193m_auts
maxes145629533max_es
maxims17399673maxims
maxis145721563max_is
menus75822843menu_s
meous76120063meou_s
metumps1334133metumps
miaous8511693miaous
miaows1145473miaows
miasms1097383miasms
miaul71612123miau_l
mibs85330483mi__bs
micas96823053mi_cas
miches134320733miches
micks135525373mi_cks
micros104115363micros
mics87435153mi__cs
midges103516483midges
midguts11296013midguts
midis85923413mi_dis
mids76541793mi__ds
midsts95510053midsts
miens76118303mi_ens
miffs134512883mi_ffs
miggs96311373mi_ggs
mights123516253mights
migs76935323mi__gs
mikes115129893mi_kes
mikvos1554023mikvos
milds86422053mi_lds
milers84625163milers
miles74645073mi_les
milks115020583mi_lks
milles84526563milles
mills75435053mi_lls
milos75428013mi_los
milpa92111403mi_lpa
milpas101710273milpas
mils66045333mi__ls
milts75430713mi_lts
mimeos104511543mimeos
mimers105520183mimers
mimes95732023mi_mes
mimics1289363mimics
minas75434113mi_nas
minces104420803minces
minds85427123mi_nds
miners84126633miners
mines75651953mi_nes
minims104514813minims
minis75432993mi_nis
miniums113910223miniums
minkes124618783minkes
minks115829273mi_nks
minors85117103minors
mints76834043mi_nts
minuet82621033minuet
minuets9259853minuets
minuses93512703minuses
minute83414293minute
minutes93513443minutes
minxes154612983minxes
mioses84318853mioses
miosis83615163miosis
mires75640883mi_res
mirins83918903mirins
mirks115122143mi_rks
mirs66940573mi__rs
mirths114912993mirths
mirzas1738183mirzas
mis58162623mi___s
miscues11312393miscues
miscuts1139183miscuts
misers85025703misers
mises74740563mi_ses
mishaps1438723mishaps
misos76523293mi_sos
miss65339423mi__ss
misses85130873misses
missis84417503missis
missus85312293missus
mists76633903mi_sts
misuse83213643misuse
misuses93216023misuses
miters84328783miters
mites75141803mi_tes
mitis75425993mi_tis
mitres83922073mitres
mitts75523753mi_tts
mix126138183mix___
mixed155717253mix_ed
mixer145017643mix_er
mixing164713943mixing
mixt136831923mix__t
mixture1635413mixture
mixtures1735753mixtures
mizens174610253mizens
mizuna1734303mizuna
mizunas1843693mizunas
mockups1733343mockups
modus85417203modu_s
moguls948553moguls
mohurs1135933mohurs
momus96116113momu_s
mops85940133m__ops
moues75732843m_oues
moxas145014393mox_as
moxies154317403moxies
mucus94015743mucu_s
muds75530653m__uds
mugs76232043m__ugs
mumps115619103m_umps
mums85732773m__ums
mumus95517283mumu_s
muns65535923m__uns
mus55946753m__u_s
muss64933763m__uss
muts64839983m__uts
nexus124710663nexu_s
nidus65913573nidu_s
nips65830923ni__ps
nisus56014393nisu_s
nixes124519623nix_es
nixies135313873nixies
oilcups1143333oilcups
pickups1754253pickups
piculs103511753piculs
pileups11365433pileups
pilus75921063pilu_s
pimps114616983pi_mps
pinup9612883pinup_
pious74621273piou_s
pips85837133pi__ps
piques1739093piques
pixels15478533pixels
pixes144323173pix_es
pixies154915513pixies
pups86032233__pups
rips66237433ri__ps
risus54216393risu_s
roups75118903_roups
scaups105411933scaups
scups95316653_scups
setups83910463setups
sieurs659043sieurs
simps94719763si_mps
sinus55523853sinu_s
sips65740103si__ps
sirup74014913sirup_
sirupy11377053sirupy
situp74414063situp_
situs55019233situ_s
sixes124526363six_es
sixmos1534813sixmos
sixtes133612403sixtes
sixths16416373sixths
slipups1133193slipups
soups75322943_soups
stoups85313273stoups
sunups837263sunups
sups64834433__sups
syrups11277953syrups
taxus125512483taxu_s
tips66436763ti__ps
tittups933353tittups
tups65628763__tups
ups55629053___ups
virus85316843viru_s
vixens16286203vixens
whaups14405753whaups
whups134210003_whups
wikiups16132083wikiups
wimps125213803wi_mps
windups1334783windups
wisps105214183wi_sps
yaups105910743_yaups
yips95226703yi__ps
yups96121603__yups
zips155723793zi__ps

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162374.73623799.8
3Display Results2372370.0763118.4
 (SQL Overall)1786912375.18534463.1
 
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.