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

137 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
noncore941195(None) 
concord12510342concord
encore8314772_encore
nonce75719822nonc__e
noncola948292noncola
noncom1039682nonco_m
noncoms1139202noncoms
nonhome1248832nonhome
nonword1149152nonword
nonwork1448422nonwork
ancone83916953_ancone
bandore10611633bandore
bonfire1287063bonfire
concave1439373concave
concede12310103concede
concern113011963concern
concert113325223concert
conchae143911643conchae
conchie143312683conchie
concise11314473concise
concoct10312903concoct
concords1358593concords
concours1239473concours
concourse1345803concourse
concur10411103concur_
concurs11311473concurs
condole102914953condole
condone102616293condone
condor94616973condor_
condores113315643condores
condors104018573condors
conform14310463conform
conjure16109073conjure
connote9311613connote
console92715983console
consort91319903consort
contort91422343contort
convoke16207173convoke
core67263113___core
donor64418193don_or_
donors75115793don_ors
downcome1644133downcome
encode9310443_encode
encored10412103_encored
encores9315213_encores
forbore12249673forbore
gonopore1146383gonopore
honor85718623hon_or_
honored11310123hon_ored
honoree10412113hon_oree
honorer1039673hon_orer
honors94816793hon_ors
ignore7269063ign_ore
income10712093_income
ionone6313443ion_one
jocose1537103jo_cose
moidore1056153moidore
mongoe94214983mongo_e
monocle1139663monocle
nacre75715363n_ac_re
nance74721843nanc__e
narcose95910383narcose
nodose738883no_dose
noisome947973noisome
nonactor1047783nonactor_
nonactors1147883nonactors
nonage7313683non_age
nonart6319193non_art
nonbody1344823nonbody
nonbook1346283nonbook
noncareer1144663noncareer
noncash1245163noncash
noncereal1157743noncereal
nonces84418833nonc_es
noncolas1048613noncolas
noncolor1046513noncolor
noncolored1354733noncolored
noncolors1147033noncolors
noncrime12116603noncrime
none45743173non___e
nonfarm1246513nonfarm
nonfood1156653nonfood
nongame1038183nongame
nonglare946373nonglare
nonheme1247133nonheme
nonhero1057913nonhero
noniron738373noniron
nonjury1744033nonjury
nonlife1038553nonlife
nonmoney1346273nonmoney
nonmoral1049233nonmoral
nonnoble1055343nonnoble
nonnovel1144413nonnovel
nonoral7313603non_oral
nonpar8168993nonpar_
nonpoor956483nonpoor
nonpros937473nonpros
nonsecure1145243nonsecure
nonstory1148103nonstory
nonuple946153nonuple
nonuse63212253non_use
nonuser7299143nonuser
nonvoter1186893nonvoter
nonwage1137163nonwage
nonwar9159423nonwar_
nonwars10109003nonwars
nonwool1046673nonwool
nonwords1247463nonwords
nonworker1644823nonworker
nonwoven1444633nonwoven
nonzero1646123nonzero
noose55624063no__ose
notcher123610933notcher
nowhere1337213nowhere
nuncle839363nunc_le
ochre103411593_o_chre
once65423083_onc__e
onshore10310013onshore
oospore939013oospore
pandore10411853pandore
poechore1547853poechore
ponce95222513ponc__e
popcorn1344903popcorn
rancor8810373rancor_
rancored1137233rancored
rancors9811373rancors
rescore95616203rescore
rondure837313rondure
roscoe839763rosco_e
score75526743__score
sincere9310553sincere
snore55424953_sn_ore
softcore1353033softcore
syncope1445383syncope
tonsure758783tonsure
uncork1239043_uncork
zoochore2245783zoochore

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271376.37621020.5
3Display Results1371370.0602283.3
 (SQL Overall)1786911376.88925938.6
 
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.