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

323 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
unmix1438897(None) 
unfix15429031unfix
unmixt15378701unmixt
admix1557722admix
bemix165011452bemix
comix163513192comix
immix1635012immix
infix15337762infix
mix126138172__mix
nix106932832_n_ix
remix145916552remix
unai44824782unai_
unais53420772unais
unbid83214632unbid
unbox1438752unbox
unci65019462unci_
uncia75015162uncia
undid72415362undid
unfit84518562unfit
unfixt16398422unfixt
unhip10178822unhip
unit45140072un_it
unlit55025462unlit
unman72715422unman
unmet74426392unmet
unmew103610072unmew
unmixed17228212unmixed
unmixes16197752unmixes
unpin72613242unpin
unrig61711412unrig
unrip72012862unrip
unsex123512632unsex
untie54425492untie
until53517742until
unwit84417522unwit
unzip16207622unzip
acmic11312333acmic
admit8319493admit
admixt1637333admixt
affix1836003affix
ami56646803_ami_
amia66836893_amia
amid77036333_amid
amie66339843_amie
amin66042243_amin
amir65129743_amir
amis66445313_amis
amnia75918633amnia
amnic95516233amnic
amnio75218043amnio
anemia82613573anemia
anemic102713693anemic
ani37751173an_i_
anil46437433an_il
anima74620073anima
anime75423203anime
animi74016663animi
animis84615943animis
anis45746463an_is
annex12310883annex
anomic102516303anomic
anomie83215963anomie
anti45536363anti_
antic75728863antic
antis55033313antis
anvil82712603anvil
auntie64317703auntie
bemixt174510363bemixt
calix145317343calix
cimex16119133cimex
comic114721813comic
commix19407753commix
cumin94616973cumin
cummin1288783cummin
cylix17448623cylix
demic105119193demic
demit84832303demit
domic104317243domic
dunlin739723dunlin
duomi8310133duomi_
emic86422743_emic
emir65918693_emir
emit65438413_emit
enmity1137483enmity
entia5318203entia
fix136236103__fix
fundi96814913fundi_
fundic12389083fundic
fungi95014133fungi_
fungic12387813fungic
funkia1336343funkia
gamic103916193gamic
gamin84422993gamin
gnomic11248593gnomic
gunman9299453gunman
gunmen9348723gunmen
helix154413013helix
hemic125718623hemic
hemin103620933hemin
homie104622523homie
humic124113243humic
humid114213763humid
hunkie133812383hunkie
imid76122273_imid
index13310983index
indie63721463indie
inia45024693in_ia
inti46626073inti_
intis55121633intis
junkie17339603junkie
kami105823643kami_
kamik105011553kamik
knit85728143kn_it
kylix19416323kylix
lamia75324323lamia
limit73126333limit
lummox1733053lummox
lungi65516053lungi_
lungis77113023lungis
mamie95826003mamie
max129045443__max
mi48249043__mi_
mib76946103__mib
mic77647633__mic
mid67354453__mid
mig65646073__mig
mil55752103__mil
mim76048413__mim
mimic111414313mimic
minx137723333__minx
mir57046763__mir
mis58162613__mis
mixt136831913__mixt
momi87524483momi_
muni65824403mun_i_
munis75022003mun_is
muntin82915183muntin
naif76839013_naif
nail45838653_nail
neif75429483_neif
nib56745183_n_ib
nil36144193_n_il
nim57142953_n_im
nims66226883_nims
nip56945983_n_ip
nit37065943_n_it
nixe115722023_n_ixe
nixy145714513_n_ixy
noil46133243_noil
noir46722433_noir
nubia7311223nubia
nudie65118673nudie
numb85520613num_b
numbs94913093numbs
numen74216793numen
numina83510843numina
nuncio837973nuncio
ohmic1237833ohmic
omit65337363_omit
ontic74418573ontic
onyx1478363on_yx
osmic939913osmic
pix126437933__pix
premix173710333premix
pundit92914183pundit
punji1438203punji_
punjis1536693punjis
punkie123513613punkie
punkin123611523punkin
radix134414593radix
rami66034093rami_
ramie75027823ramie
refix155212483refix
remex146315793remex
remit75737223remit
remixt155014853remixt
runic73615773run_ic
semi65127223semi_
semis74623533semis
six105339743__six
smit65138403_smit
snail57020203snail
snib66522973sn_ib
snip66424653sn_ip
snit46342473sn_it
subfix1835073subfix
submit10312673submit
suffix1935233suffix
summit10311543summit
sunlit61516103sunlit
tamis76728723tamis
timid84815713timid
tumid84114023tumid
tunic74018223tun_ic
um47338833u_m__
umami939883umami_
umamis1038273umamis
umbo85516653u_mbo
umiac938953u_miac
umiak1137663u_miak
umiaq1656813u_miaq
umm711921263u_m_m
ump76130443u_m_p
umps85721943u_mps
un28341133un___
unakin10310963unakin
unapt710421593unapt
unarm7314453unarm
unary8315993unary
unau43924153un_au
unaus53216573unaus
unban72114333unban
unbar71913613unbar
unbe65319273un_be
unbind93011423unbind
uncap9312283uncap
unchic1338643unchic
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
uncle7317053uncle
unclip1046993unclip
unco66021403un_co
uncoil8811853uncoil
uncomic1346923uncomic
uncos74117033uncos
uncoy104111413uncoy
uncus74014983uncus
uncut73219173uncut
unde55825483un_de
undee65327273undee
under64624213under
undies73821963undies
undine7817263undine
undo55620153un_do
undue66715553undue
undy85015163un_dy
unfair936233unfair
unfed94614223unfed
unfits93910293unfits
unfixed18218563unfixed
unfixes17238113unfixes
ungird887973ungird
ungirt71112713ungirt
ungot61718063ungot
unguis738443unguis
unhair937333unhair
unhat81119263unhat
unific1137463unific
unify113611113unify
union54519793union
unisex1358353unisex
unite54828383unite
units54923433units
unity84918493unity
unjam1448723unjam
unkind113310573unkind
unkink9308713unkink
unknit1068593unknit
unlaid7311753unlaid
unlay84613703unlay
unled64021073unled
unlet54133333unlet
unlike102614063unlike
unlink104011013unlink
unlive92712333unlive
unmade92911063unmade
unmake122811213unmake
unmans82211993unmans
unmask1265903unmask
unmeet83815743unmeet
unmesh1145793unmesh
unmews11326523unmews
unmined102612953unmined
unmiter9310393unmiter
unmitre936993unmitre
unmixing1835543unmixing
unmold9148313unmold
unmoor836313unmoor
unmown11296093unmown
unnail6410583unnail
unpaid939473unpaid
unpeg8309363unpeg
unpen72913573unpen
unpick1446903unpick
unpile81914323unpile
unpins82312383unpins
unrigs7159003unrigs
unripe82012093unripe
unrips8199453unrips
uns35936753un__s
unsaid7411833unsaid
unsay83212843unsay
unset54532433unset
unsew83912693unsew
unsexy16296903unsexy
unship1148033unship
untidy1059153untidy
untied73720813untied
unties64326923unties
unto45824283un_to
untrim8310673untrim
unveil957343unveil
unvext1658173unvext
unwed94114873unwed
unwet84423173unwet
unwind102610543unwind
unwise9510803unwise
unwish1239093unwish
unwits9389893unwits
unwon84512343unwon
unzips17175273unzips
uplit76020803uplit
urbia7311133urbia
ureic74514463ureic
uremia82910893uremia
uremic103410513uremic
uric63624933u_ric
ursid6311483ursid
varix154313503varix
vomit102622573vomit
yomim12510073yomim
zamia165115213zamia

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 Filter178691836670.1101624463.6
2DLD Change Limit836673233.83021845.2
3Display Results3233230.0764250.0
 (SQL Overall)1786913234.01644494.8
 
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.