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

504 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
confess1239990(None) 
confers124120091confers
coffees15329572coffees
coffers154112692coffers
coinfers13349502coinfers
concuss1138062concuss
cones76457422con_e_s
coneys115218422con_eys
confabs1435392confabs
confect143614272confect
confects153110872confects
confer114018682confe_r
confessed1546052confessed
confesses1438622confesses
confessor1444342confessor
confits122811422confits
confuse1238852confuse
confuses13310362confuses
congees103517922congees
congers104223232congers
conges94928172conge_s
congest104618772congest
congests113510382congests
congress1138072congress
conies84338592conie_s
conifers133611702conifers
conkers133721042conkers
conners94023112conners
contes84432912conte_s
contessa1044582contessa
contest93523232contest
contests103413382contests
conveys15308222conveys
countess103710052countess
coxless1637742coxless
coyness1277322coyness
sonless72612612sonless
awnless1035923awnless
bonders104120663bonders
bondless1148813bondless
boneless10310213boneless
boners84825433bon_ers
bones76446533bon_e_s
boniest93318993boniest
boniness102211803boniness
bonkers134015303bonkers
bonnes85621453bonne_s
bonnets94812803bonnets
bonuses94212953bonuses
bonzes175116103bonze_s
boonless10328353boonless
bowless123310313bowless
cafes106426923c_afe_s
cancels114113313cancels
cancers114018583cancers
caners84629203can_ers
canes75350373can_e_s
canfuls1248423canfuls
cankers134418753cankers
cannels93413363cannels
canners93822663canners
canoers94318373canoers
canoes84725883canoe_s
canoness1039393canoness
canters94827733canters
canvass12376873canvass
capless114312763capless
caress85720263c_aress
carless95118493carless
censers94313903censers
censes83721803cense_s
centers94420603centers
centeses1079443centeses
centesis1058143centesis
cess65326053c___ess
chafers154512743chafers
chafes145017913chafe_s
chess105016923c__hess
chinless1337493chinless
cinders104617763cinders
cines75239683cin_e_s
cloners94514823clon_ers
clones84526563clon_e_s
clonuses1057133clonuses
coalers94419353coalers
coalless1038193coalless
coatees93816553coatees
coaters93525793coaters
coatless1039693coatless
coaxers164311083coaxers
coaxes154715633coaxe_s
cobbers134114753cobbers
cobles104622883coble_s
cobwebs1631933cobwebs
cockers153618333cockers
codders114114453codders
codecs115112933co_decs
codeless112010113codeless
codens94821013co_dens
coders95426983co_ders
codes86247293co_de_s
codfish1637163codfish
codgers115113933codgers
coeds85920163co__eds
coffee144113743coffe_e
coffer144112863coffe_r
coffins153110193coffins
coffles152610003coffles
coffrets1645363coffrets
coffs134916303co_f_fs
cognises11610043cognises
coifed124113063coife_d
coiffes1546803coiffes
coifs105718703coif__s
coilers93619903coilers
coiners93620753coiners
coinfect15276843coinfect
coinfects16344573coinfects
coinfer12419393coinfe_r
cointers103616423cointers
cokes115537193co_ke_s
coldest102514763coldest
coldness1137953coldness
coles76055063co_le_s
coleus86818273co_leus
colies84837053colie_s
collets93517903collets
colters93522443colters
combers134516623combers
combes125321733combe_s
comers105328083co_mers
comes97246993co_me_s
comets105823583co_mets
comfiest1539133comfiest
comfiness1646953comfiness
comfits14328743comfits
comfreys1843333comfreys
compass13379563compass
compels133210893compels
compress1439053compress
comtes106222813comte_s
conatus9310463conatus
conceal113313023conceal
conceals123111033conceals
concede12310103concede
concedes13311063concedes
conceit113218073conceit
conceits122813613conceits
concent114422513concent
concents122516603concents
concept133314443concept
concepts143110303concepts
concern113011963concern
concerns122710833concerns
concert113325223concert
concerts123016063concerts
conchas144013313conchas
conches144019813conches
conchos144313963conchos
conchs134714903con_chs
concise11314473concise
concurs11311473concurs
condemn1237113condemn
condemns1336293condemns
condense1179613condense
condenses12710133condenses
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333con_dos
cone67256963con_e__
coned86040053con_e_d
coney105932883con_e_y
confab1347063conf_ab
conferee13613733conferee
conferees14610623conferees
conferva1644433conferva
confervas1744823confervas
confessing1647183confessing
confession15126503confession
confessors1544833confessors
confetti1345993confetti
confetto1346253confetto
confide13310203confide
confiders1537483confiders
confides14310573confides
confine12315583confine
confiners1439953confiners
confines13315653confines
confirm1437363confirm
confirms1536303confirms
confit113316403conf_it
conflux1943003conflux
conform14310463conform
conforms1538873conforms
confrere1347563confrere
confreres1448033confreres
confused1437033confused
confute1239263confute
confuters1437793confuters
confutes1339843confutes
congas94417033con_gas
conge85227593conge__
congeal104011683congeal
congeals11309863congeals
congee96024473conge_e
congeed113212313congeed
conger95024273conge_r
congius103210073congius
congoes103617303congoes
congos94219883con_gos
congous103615083congous
conics103920593con_ics
conifer123212643conife_r
conines93827793conines
conins84327233con_ins
conioses10313323conioses
coniosis1048143coniosis
coniums11311863coniums
conked135019113conke_d
conker124721553conke_r
conks115525703con__ks
connect113515743connect
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conns75024233con__ns
conoids10813883conoids
conquers1938223conquers
conquest1939553conquest
conquests2045363conquests
cons66057693con___s
consensus1144923consensus
consent93723113consent
consents102715893consents
consist9316033consist
consists10310593consists
consols92914073consols
consuls92412323consuls
conte76633203conte__
contemn1137803contemn
contemns1237403contemns
contend103511893contend
contends112810573contends
content94326153content
contents104018213contents
contessas1145023contessas
context163913433context
contexts17378653contexts
contos84923233con_tos
contras93015623contras
contuse9311413contuse
contuses10413453contuses
conus76726533con__us
convect143114483convect
convects153410993convects
convene123314323convene
convenes132916913convenes
convent123919413convent
convents132614603convents
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446893conversos
convert123721473convert
converts133213553converts
convex18367743conve_x
convexes20278273convexes
convey144610223conve_y
convoys15267023convoys
cooees85621893co_oees
cooers84324563co_oers
cooeys114914483co_oeys
coofs105924713coof__s
cookers134619463cookers
cookeys16478503cookeys
cookless14258633cookless
coolers93522493coolers
coolest9318643coolest
coolness1037743coolness
coopers114019483coopers
cooters94525733cooters
copens106119963co_pens
copers104629843co_pers
copes97747103co_pe_s
copiers114215963copiers
copies104130313copie_s
coppers133519753coppers
copses104922483copse_s
copters113621283copters
coquets18399893coquets
corbels113813593corbels
corders104520883corders
cordless11299963cordless
coreless103013833coreless
corers85231073co_rers
cores76361853co_re_s
corkers134118853corkers
cormels113813373cormels
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornets94820573cornets
cornfed1337383cornfe_d
corniest102117303corniest
corniness112611183corniness
cornuses10310033cornuses
corpses113913813corpses
corses84433463corse_s
corsets94819803corsets
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
cosecs105015213co_secs
coses76949493co_se_s
cosets85824403co_sets
coseys115215813co_seys
coshers123618183coshers
coshes115022783coshe_s
cosies84932163cosie_s
cosiest93819853cosiest
cosiness103214283cosiness
coss66143493co___ss
cossets95014283cossets
costers94128343costers
costless10310003costless
cotes76347843co_te_s
cotters94323453cotters
coulees9315513coulees
counsels1037583counsels
counters103320193counters
countless1146373countless
coupes105022523coupe_s
courses94218893courses
couters93827303couters
covens114919263co_vens
covers114627963co_vers
coves105539173co_ve_s
covets114819643co_vets
coveys145413503co_veys
cowers114625533co_wers
cowfish1836433cowfish
cowiest123614673cowiest
cowpeas1437273cowpeas
coxes145430863co_xe_s
coyest11316053co_yest
cozens176314923co_zens
cozes166033243co_ze_s
cozeys204610913co_zeys
cozies174521413cozie_s
coziest184014353coziest
coziness19319823coziness
cozzes164510893cozze_s
cress75022833c__ress
crones84729243cron_e_s
cronies9622513cronie_s
cropless1237793cropless
crownless1443423crownless
cuffless1634293cuffless
cunners93913473cunners
curfews15294913curfews
cypress1434663cypress
doffers14359853doffers
donees74519493don_ees
doneness9411513doneness
donkeys15426663donkeys
donnees84210363donnees
donzels1735393donzels
downless1236363downless
dunness8298983dunness
fess76529163___fess
finless102810783finless
fogless1138193fogless
fondest11312403fondest
fondness1237213fondness
funfest13348083funfest
funfests14253563funfests
goddess1035263goddess
godless938403godless
gofers104711513go_fers
goffers14409213goffers
golfers114410083golfers
gonefs10439873gon_efs
goneness9310763goneness
goners74420173gon_ers
gunless8299633gunless
honers94324973hon_ers
hones88144493hon_e_s
honest94822423hon_est
honeys124016083hon_eys
honkers143315233honkers
honkeys17439513honkeys
hoofers134513333hoofers
hoofless14258013hoofless
hornfels1443793hornfels
hornless1137363hornless
hostess103210243hostess
hotness1038613hotness
iciness938863icin_ess
icones84616383icon_e_s
infers93615443_infers
infest93315433_infest
infests10279793_infests
innless7288293innless
ionises72916433ionises
ironness836953ironness
jobless16237563jobless
jones125028183jon_e_s
joneses1438963jon_eses
joyless17226513joyless
kinless113310273kinless
lioness739103lion_ess
loafers10349463loafers
loess55714703lo__ess
loneness8512093loneness
loners64225813lon_ers
longers84819543longers
longes75925573longe_s
longest84114953longest
longness938553longness
lornness836493lornness
lowness1037813lowness
manless93012933manless
mondes94322353monde_s
moneys115513623mon_eys
mongers104217273mongers
monies83233163monie_s
monkeys16407423monkeys
montes84226933monte_s
moonless10278043moonless
ness45526563__n_ess
nonces84418833nonce_s
nones55639133non_e_s
nonets64118703non_ets
nonfans1037533nonfans
nonnews1035313nonnews
nonuses73313863nonuses
nounless837253nounless
nowness1037033nowness
obsess845943_obsess
offers12349963_offers
ogress7529503_ogress
oneness7512143_oneness
ones46146533_on_e_s
onsets64013543_onsets
onuses65616253_onuses
poetess938933poetess
ponces104720843ponce_s
ponders103618853ponders
pones74547043pon_e_s
pongees104212543pongees
ponies84833463ponie_s
pontes83627853ponte_s
possess9419123possess
profess1237713profess
reconfers1437213reconfers
rodless8310073rodless
rolfers104011813rolfers
rondels82510053rondels
ronnels7318623ronnels
roofers105013903roofers
roofless11316733roofless
runless72810423runless
scoffers16286133scoffers
sconces113811453sconce_s
scones84521303scon_e_s
sinless73014213sinless
sonders83820713sonders
sondes74922873sonde_s
sones55444143son_e_s
songfest1236843songfest
songfests1342983songfests
songless9218823songless
sonnets74211993sonnets
sunless73013693sunless
toeless72612393toeless
toffees13327083toffees
toneless8610393toneless
toners64128003ton_ers
tones56048663ton_e_s
tongers84116013tongers
toniest73218903toniest
tonlets73212503tonlets
tonners73816403tonners
tonnes65320853tonne_s
tonuses73612193tonuses
topless92511123topless
townless1135653townless
toyless10268713toyless
unless62413073_unless
votress1035483votress
vowless13246603vowless
wanness102610683wanness
winless103212283winless
woeness1020211543woeness
wolfers13409633wolfers
wonders113315993wonders
wonners104312813wonners
woofers133810583woofers
wornness1136363wornness
yonkers14379823yonkers
zoneless1737823zoneless
zoners155115993zon_ers
zones145528043zon_e_s

Search took 8 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.423422437.4
2DLD Change Limit1340275047.11018850.5
3Display Results5045040.2032482.8
 (SQL Overall)1786915047.73623098.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.