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

200 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
noncom103968(None) 
noncoms1139181noncoms
condom114215362condom
nonce75719822nonc_e
nonces84418832nonces
noncola948292noncola
noncore9411952noncore
nonhome1248832nonhome
syncom1336092syncom
ancon75718233_ancon
anonym1136383anon_ym
banco94019393banco_
bancos104713893bancos
bonbon10310073bonbon
bongo85720943bongo_
bongos95316653bongos
boocoo1039003boocoo
boom87435673bo__om
bosom95516923bo_som
bottom1048713bottom
bronco10179493bronco_
broncos11188073broncos
bunco94616083bunco_
buncos104011593buncos
coco87330603co_co_
cocoa98517883co_coa
cocos95624693co_cos
coelom10310423coelom
conch124620073conc_h
concha134213283concha
concho134414263concho
conchos144313953conchos
conchs134714903conchs
conchy163710223conchy
concoct10312903concoct
concord12510343concord
concur10411093concur
condo85322593condo_
condoms124214083condoms
condor94616963condor
condos94322333condos
conform14310453conform
congo85623133congo_
congos94219883congos
congou94313243congou
conium10415313conium
consol82614113consol
conto76027173conto_
contos84923233contos
convoy14348543convoy
coocoo1069693coocoo
corncob1345663corncob
coxcomb2243293coxcomb
dogdom1186363dogdom
donjon1436463donjon
donor64418193don_or
doom76430073do__om
downcome1644133downcome
eonism83213533eonism
fandom122110893fandom
fantom112110803fantom
genom83716843gen_om
gonion73612833gonion
gonium949803gonium
gonof95218653gon_of
gonzo15310243gonzo_
hansom11219153hansom
honcho14389383honcho
honchos15369573honchos
honor85718623hon_or
incog838253_incog
income10712093_income
ionium8610913ionium
junco144612203junco_
juncos15449233juncos
loco67030743lo_co_
locos75822603lo_cos
locum94812173lo_cum
loom67035053lo__om
mondo85721233mondo_
mondos95217333mondos
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
monism104016313monism
mono66036713mon_o_
monocot11412013monocot
monos75930863mon_os
nance74721843nanc_e
nances83618643nances
nancy105214923nanc_y
nanism8311203nanism
narco76718243narco_
narcoma1145823narcoma
narcos86714203narcos
neocon836713neocon
nicol71113293n_icol
ninon55517383nin_on
nock106127183no_c_k
nocks115121013no_cks
nohow1137293no_how
noisome947963noisome
nolo46229313no_lo_
nolos54423353no_los
nom510450643__n_om
nomism103010953nomism
nomoi76012533no_moi
nomos75919743no_mos
nona46929063non__a
nonacid101210843nonacid
nonactor1047773nonactor
nonage7313683nonage
nonagon847313nonagon
nonart6319193nonart
nonas55126653non_as
nonbody1344813nonbody
nonbook1346283nonbook
noncash1245163noncash
noncolas1048613noncolas
noncolor1046513noncolor
noncombat1555433noncombat
noncrime12116603noncrime
none45743173non__e
nonego737013nonego
nonegos837133nonegos
nones55639133non_es
nonet54540843non_et
nonets64118703nonets
nonfan948293nonfan
nonfarm1246513nonfarm
nonfat9512183nonfat
nonfood1156653nonfood
nongame1038173nongame
nongay10169153nongay
nonheme1247133nonheme
noniron738373noniron
nonman8412363nonman
nonmen8412833nonmen
nonpar8168993nonpar
nonpoor956483nonpoor
nonpros937463nonpros
nonstop9106903nonstop
nontax1348413nontax
nonuse63212253nonuse
nonwar9159423nonwar
nonwool1046673nonwool
nonword1149153nonword
nonwork1448423nonwork
nonyl849773non_yl
nonyls957853nonyls
noo37154043no__o_
nook85728493no__ok
noon47134623no__on
norm66429813no__rm
nostoc868183nostoc
notch105613323notc_h
notion64516583notion
notum7611683no_tum
nuncio837973nuncio
nuncios937113nuncios
nuncle839363nuncle
once65423083_onc_e
oncet74626543_oncet
onion54320973_onion
onium73115533_onium
ono36838033_on_o_
onos46229003_on_os
onto46127663_onto_
poco86826153po_co_
pogrom1138593pogrom
pompom1436493pompom
ponce95222513ponc_e
ponced114314813ponced
ponces104720843ponces
poncho133310123poncho
ponchos143410703ponchos
ponton83217643ponton
rancor8810373rancor
random92513553random
ransom82410943ransom
rondo65218373rondo_
rondos74616723rondos
ronion63315643ronion
ronyon9309133ronyon
room66235083ro__om
roscoe839763roscoe
sitcom1036893sitcom
sodom8814903so_dom
syncoms1435943syncoms
tomcod1135783tomcod
tondo69718683tondo_
tondos75115913tondos
toom66532933to__om
unco66021403_unco_
uncos74117033_uncos
uncoy104111413_uncoy
venom103914863ven_om
wonton93410963wonton
zoom156722103zo__om

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.1561145455.1
2DLD Change Limit1127162006.56317174.5
3Display Results2002000.0633174.6
 (SQL Overall)1786912006.78226347.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.