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

182 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
commixes217734(None) 
commies133718441commi_es
commixed2264741commixed
cammies134016472cammi_es
combines142814622combines
commie124215522commi_e_
commits133812372commi_ts
commix19407752commix__
commixt20357622commix_t
commodes1539092commodes
commoves1736962commoves
communes143411232communes
commutes143011872commutes
compiles14311982compiles
immixes1835062_immixes
mommies103912272mommi_es
pommies133712842pommi_es
tommies113812982tommi_es
admixes1765963_admixes
ammines11312673_ammines
apomixes1934853apomixes
bemixes18338653_bemixes
bollixes1747203bollixes
bombyxes2442603bombyxes
camises114218463c_amises
cammie124615293cammi_e_
camomiles15155633camomiles
carmines123617863carmines
cervixes2054603cervixes
chamises153513313chamises
chammies172910153chammi_es
chemises153211983chemises
cimices13279803c_imices
climaxes1944613climaxes
coadmires1444023coadmires
coamings13349293coamings
coaxes154715633co__axes
cocaines121314443cocaines
coccyxes2142013coccyxes
codeines113114523codeines
codices12512583co_dices
codrives1437663codrives
coesites101313093coesites
cognises11610043cognises
cognizes2058023cognizes
colies84837053co_li_es
collides113214463collides
collies94326583colli_es
comakes154413643co_makes
comates114123633co_mates
combes125321733co_m_bes
combine133014713combine_
combined15269183combined
combineds16255283combineds
combiner14259723combiner
combiners15247943combiners
combings15348323combings
comedies13311833comedies
comes97246993co_m__es
comfier1439163comfi_er
comfiest1539133comfi_est
comfiness1646953comfiness
comfits14328743comfi_ts
comics124015563co_mi_cs
comings124013533co_mings
comities12317783comities
comix163513193co_mix__
commands15318813commands
commas124814573comm__as
commences17139573commences
commends15308463commends
comments142913873comments
commerces17147233commerces
commingles1744083commingles
comminutes1685613comminutes
commit124016703commi__t
committed1645713committed
committee1546233committee
committees1644053committees
commixing2345183commixing
commixtures2452183commixtures
commode1438123commode_
commoner142710633commoner
commoners15339783commoners
commonest1549253commonest
commons13311043comm_ons
commove1635963commove_
commoved1844763commoved
commune13329353commune_
communed15338203communed
communer14349293communer
communers15338403communers
communises1646553communises
communizes2546243communizes
commute134310423commute_
commuted15288963commuted
commuter143010133commuter
commuters15378883commuters
compares143816433compares
comperes143217973comperes
competes144117243competes
compile13312443compile_
compiled1537813compiled
compiler1438373compiler
compilers1537053compilers
complexes22308093complexes
complices1739253complices
complies14314523complies
complines15312833complines
composes145017113composes
compotes144716513compotes
comprises15510943comprises
comprizes2468943comprizes
computes143914533computes
comrades13149773comrades
comtes106222813co_m_tes
confides14310573confides
confines13315653confines
conies84338593co_ni_es
coniines10415363coniines
conines93827793co_nines
connives1339723connives
convexes20278273convexes
cookies133719273cooki_es
coolies93824963cooli_es
coombes133810663coom_bes
cooties93725733cooti_es
copies104130303co_pi_es
coppices1638243coppices
corbies113520113corbi_es
cordites11314603cordites
cornices12713283cornices
corries94026783corri_es
cortexes1797613cortexes
cortices12615003cortices
cosies84932153co_si_es
cosines94122673co_sines
cosmids1237633cosmi_ds
cosmisms1446223cosmisms
cosmists1237993cosmists
cosmoses1239703cosmoses
cowhides1735993cowhides
cowpies143314283cowpi_es
cowpoxes2244513cowpoxes
cowries124218013cowri_es
cowrites133011593cowrites
coxes145430863co___xes
cozies174521413co_zi_es
crummies1437643crummi_es
cummins1358963cummi_ns
domaines11611063domaines
domines102918973do_mines
dummies123012133dummi_es
fomites123613203fo_mites
gimmies123010103gimmi_es
gummites1346163gummites
homies114524723ho_mi_es
homines123518633ho_mines
hommoses1538153hommoses
immies102412423_immi_es
immixed1933563_immixed
jammies183611293jammi_es
jemmies18318333jemmi_es
jimmies18328773jimmi_es
koumises1444593koumises
lummoxes1942553lummoxes
mammies104314763mammi_es
mixes147224403___mixes
mummies103812843mummi_es
panmixes1934913panmixes
pommie123710503pommi_e_
premixes193110083premixes
remixes164313873_remixes
romaines10512513romaines
roomies93017243roomi_es
rummies113212793rummi_es
somites94219113so_mites
tammies113814683tammi_es
tummies113012033tummi_es
unmixes16197753_unmixes
yummies14359533yummi_es
zombies2037983zombi_es

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621828.81316584.8
3Display Results1821820.0802275.0
 (SQL Overall)1786911829.04919747.0
 
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.