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

231 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
commix1940776(None) 
comix163513201co_mix
commie124215521commie
commit124016701commit
commixt20357621commixt
cammie124615292cammie
comfit133112422comfit
comic114721812co_mic
comma114514792comm_a
commas124814572commas
commies133718452commies
commits133812382commits
commixed2264742commixed
commixes2177352commixes
common12310802common
commy144712642comm_y
cosmic12410342cosmic
cosmid11810642cosmid
cummin1288782cummin
immix1635032_immix
pommie123710502pommie
admix1557733_admix
bemix165011453_bemix
bollix1538053bollix
bombax1935753bombax
bombyx2232693bombyx
cadmic1338983cadmic
calix145317353c_alix
camail10314833camail
cambia124913153cambia
cammies134016483cammies
campi116217783campi_
cervix1865163cervix
chamoix21275643chamoix
chemic153012093chemic
chymic18317883chymic
cimex16119133c_imex
climax1735653climax
coadmit1247833coadmit
coaming123818323coaming
coati75624643coati_
coatis85122603coatis
coax136922983co__ax
cobia94117513co_bia
cocain101315013cocain
cocci82812673cocci_
coccic8298943coccic
coccid102910743coccid
coccyx1942663coccyx
cochin131313203cochin
codeia94112193codeia
codein94916723codein
codex155817583co_dex
codlin94516443codlin
coedit9316243coedit
coempt12311033coempt
coffin14339813coffin
coheir1137583coheir
coif96337913co__if
coil66439653co__il
coin66645353co__in
coir66327243co__ir
cojoin1539503cojoin
colic95726173co_lic
colin76231693co_lin
collie83621993collie
coma87134853co_m_a
comade114415323comade
comae97128423co_mae
comake144413423comake
comal95125133co_mal
comas95833003co_mas
comate104124843comate
comatic131816943comatic
comatik15139723comatik
comb106632113co_m_b
combat12316753combat
combe116223543co_mbe
combed135516543combed
comber125118503comber
combes125321733combes
combine133014723combine
combing143714733combing
combo114519433co_mbo
combos125316613combos
combs116122963co_mbs
come87547703co_m_e
comedic14158633comedic
comedo11359603comedo
comedy14378233comedy
comely134213733comely
comer95832693co_mer
comers105328083comers
comes97246993co_mes
comet95946073co_met
cometh134811683cometh
cometic131215723cometic
comets105823583comets
comfier1439163comfier
comfits14328743comfits
comfy153710213co_mfy
comics124015563comics
coming114225453coming
comitia1139723comitia
comity13312713comity
command14399213command
commata1338483commata
commend144010183commend
comment1310317703comment
commixing2345193commixing
commode1438123commode
commons13311043commons
commove1635963commove
commune13329363commune
commute134310443commute
comose105016853comose
comous10816513comous
comp106731253co_m_p
compas125817063compas
comped135919873comped
compel124412893compel
compile13312443compile
comping143518593comping
complex2037243complex
complin13312073complin
comply152810383comply
compo115318573co_mpo
compos124818803compos
comps115526053co_mps
compt116328223co_mpt
compts125216653compts
comte96125473co_mte
comtes106222813comtes
confit113316403confit
congii957363congii
coni65534803co_ni_
conic95329793co_nic
conin76232723co_nin
conoid9818883conoid
convex18367743convex
cookie123716043cookie
coolie83821603coolie
coomb115615703coom_b
coombe124110093coombe
coombs124210193coombs
cootie84223093cootie
corbie103618203corbie
coremia11310363coremia
corgi8316083corgi_
corgis9314413corgis
coria75828323co_ria
corm85735383corm__
cormel103815603cormel
cormoid12310403cormoid
corms95626223corm_s
corrie83621233corrie
cortex15311473cortex
cortin82423153cortin
corvid12310473corvid
cosie74728263co_sie
cosmids1237633cosmids
cosmism1337013cosmism
cosmist11311333cosmist
cosmos10311753cosmos
coulis84018763coulis
cousin8517163cousin
covin105621123co_vin
cowman13910373cowman
cowmen13810923cowmen
cowpie133511513cowpie
cowpox2035003cowpox
cowrie113814283cowrie
cox1210346783co___x
cozie163519133co_zie
crummie1336153crummie
cumbia12379893cumbia
cumin94616973c_umin
cummer124414593cummer
cummins1358963cummins
cylix17448623c_ylix
cymlin1337313cymlin
cymoid1459473cymoid
dammit11311133dammit
domain9511323domain
domic104317243do_mic
dormie9312623dormie
dormin9312313dormin
formic13310453formic
fornix1636033fornix
gimmie11298183gimmie
holmic1338783holmic
homie104622533ho_mie
hommos13128503hommos
jimmie17376473jimmie
koumis1237623koumis
lomein8410203lomein
lummox1733053lummox
mammie94313783mammie
mix126138183___mix
momi87524483mo_mi_
momma85111053momm_a
mommas94110653mommas
mommies103912273mommies
mommy114010753momm_y
nomoi76012533nomoi_
ohmic1237833_ohmic
omit65337373_o_mit
osmic939913_osmic
pommee122813283pommee
pommel12277453pommel
pommies133712843pommies
pommy14449863pomm_y
premix173710333premix
recommit1445553recommit
remix145916553_remix
roomie83013873roomie
summit10311543summit
tammie104212693tammie
tommed113310143tommed
tommies113812983tommies
tomming12359243tomming
tommy124712233tomm_y
tomtit8413853tomtit
unmix14388973_unmix
vomit102622573vo_mit
wimmin1336153wimmin
wormil1138043wormil
yomim12510083yo_mim
zombi1838993zombi_
zombie1937323zombie
zombis1936283zombis

Search took 7 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.390458182.1
2DLD Change Limit1127162316.22018121.5
3Display Results2312310.0763039.5
 (SQL Overall)1786912316.68626726.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.