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

485 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
sconces11381145(None) 
sconce104711721sconce_
sconced12359171sconced
scones84521301scon_es
conches144019812_conches
conchs134714902_conchs
cones76457422_con_es
conges94928172_conges
conies84338592_conies
contes84432912_contes
ensconces1344742ensconces
icones84616382icon_es
nonces84418832_nonces
ponces104720842_ponces
scenes84520352scen_es
sciences1238772sciences
scoleces1237082scoleces
scolices1238732scolices
scone74621832scon_e_
scooches15188412scooches
scopes104719592sco_pes
scorches15189142scorches
scores84725922sco_res
scotches15179472scotches
scouses93313242scouses
seances93015342seances
secondes1138132secondes
sondes74922872s_ondes
sones55444142s_on_es
spences113413922spences
sponges10311042sponges
stances93715962stances
stones65130032ston_es
acnes75922623ac_n_es
acnodes1037833acnodes
aconites10314353aconites
agones75719863agon_es
agonies83016623agonies
ancones93116343ancon_es
astonies8815093astonies
atones65225773aton_es
atonies75320953atonies
axones134614513axon_es
blondes104213163blondes
bocces123912023_bocces
bones76446533_bon_es
bonnes85621453_bonnes
bonzes175116103_bonzes
boonies93422483boonies
bounces113813683bounces
broncos11188073broncos
broncs101611153bronc_s
bronzes183510403bronzes
calces104420053_calces
cancel105316683_cancel
cancels114113313_cancels
cancer104220923_cancer
cancers114018583_cancers
canes75350373_can_es
canoes84725883_canoes
censes83721803_censes
chances145218093chances
choices142010613choices
cinches144215773_cinches
cines75239683_cin_es
clones84526563clon_es
coaches144018693_coaches
coacts105314333_coacts
coaxes154715633_coaxes
cobles104622883_cobles
cocas95926573_co_cas
coccus979283_coccus
cocks135227163_co_cks
cocos95624693_co_cos
codecs115112933_codecs
codes86247293_co_des
codices12512583_codices
coerces11311943_coerces
cokes115537193_co_kes
coles76055063_co_les
colies84837053_colies
combes125321733_combes
comes97246993_co_mes
comtes106222813_comtes
concaves1538913_concaves
conceal113313013_conceal
conceals123111013_conceals
concede12310103_concede
concedes13311063_concedes
conceit113218073_conceit
conceits122813613_conceits
concent114422513_concent
concents122516603_concents
concept133314443_concept
concepts143110303_concepts
concern113011963_concern
concerns122710833_concerns
concert113325223_concert
concerts123016063_concerts
conch124620073_conc_h
concha134213283_concha
conchas144013313_conchas
conchies153214853_conchies
concho134414263_concho
conchos144313963_conchos
conchy163710223_conchy
concise11314473_concise
concur10411103_concur
concurs11311473_concurs
concuss1138063_concuss
condoes104319203_condoes
condos94322333_condos
conduces13129783_conduces
cone67256963_con_e_
coned86040053_con_ed
coney105932883_con_ey
coneys115218423_coneys
confer114018683_confer
confers124120093_confers
confess12399903_confess
congas94417033_congas
conge85227593_conge_
congee96024473_congee
congees103517923_congees
conger95024273_conger
congers104223233_congers
congest104618773_congest
congoes103617303_congoes
congos94219883_congos
conics103920593_conics
conines93827793_conines
conins84327233_conins
conked135019113_conked
conker124721553_conker
conkers133721043_conkers
conks115525703_con_ks
conned95119703_conned
conner84423963_conner
conners94023113_conners
conns75024233_con_ns
cons66057693_con__s
conte76633203_conte_
contest93523233_contest
contos84923233_contos
conus76726533_con_us
convex18367743_convex
convey144610223_convey
conveys15308223_conveys
cooches143515833_cooches
cooees85621893_cooees
copes97747103_co_pes
copies104130303_copies
copses104922473_copses
cores76361853_co_res
cornices12713293_cornices
corses84433463_corses
corves115122523_corves
cosecs105015213_cosecs
coses76949493_co_ses
coshes115022783_coshes
cosies84932153_cosies
cotes76347843_co_tes
couches144020473_couches
coupes105022523_coupes
coves105539173_co_ves
coxes145430863_co_xes
cozes166033243_co_zes
cozies174521413_cozies
cozzes164510893_cozzes
crones84729243cron_es
cronies9622503cronies
cruces105117543_cruces
dances95120653_dances
donees74519493_donees
drones75023433dron_es
dunces95215753_dunces
ebonies9312883ebonies
enounces1037603enounces
ensconce1244713ensconce_
ensconced1443343ensconced
essences1047563essences
evinces1237803evinces
fences114617113_fences
fiances12310673fiances
flounces1335103flounces
forces114422133_forces
frontes104214163frontes
frounces1336183frounces
glances104113143glances
goonies83618333goonies
hances115621283_hances
hones88144493_hon_es
icons76516493icon__s
irones64724013iron_es
ironies7517423ironies
jaunces16307423jaunces
jones125028183_jon_es
jounces16369853jounces
lances84824103_lances
launces9329003launces
leones64417723leon_es
licences12129323licences
longes75925573_longes
loonies73919543loonies
lucences12137313lucences
minces104420803_minces
mondes94322353_mondes
monies83233163_monies
montes84226933_montes
nances83618643_nances
nascences1346233nascences
nonce75719823_nonce_
nones55639133_non_es
nuances938523nuances
once65423083__once_
oncet74626543__oncet
ones46146533__on_es
oscines9310363oscin_es
ounces83617773_ounces
ozones1539393ozon_es
peones83821043peon_es
peonies93620153peonies
phones114121213phon_es
phonies123717513phonies
ponce95222513_ponce_
ponced114314813_ponced
pones74547043_pon_es
ponies84833463_ponies
pontes83627853_pontes
pounces114113893pounces
prances113618773prances
princes113015143princes
quinces183210433quinces
rances84625443_rances
saices84221803s_aices
sanes55649073s_an_es
sanies63031953s_anies
sauces84919503s_auces
saxonies1537913saxonies
scabies11613333scabies
scales84529313sc_ales
scanned104110893scanned
scanner94411813scanner
scanners10379703scanners
scans74625103scan__s
scanted104114393scanted
scanter94215183scanter
scantest101710183scantest
scanties103215423scanties
scants85219723scan_ts
scapes105122263sc_apes
scarce104013633scarce_
scarcer113911373scarcer
scarcest12169173scarcest
scares85033003sc_ares
scarves124511623scarves
scathes124515713scathes
scenas84114703scen_as
scended11329873scended
scends95213003scen_ds
scene77220573scen_e_
scenics1137773scenics
scented102811883scented
scents85317023scen_ts
schemes1489663schemes
schmoes14308543schmoes
schnaps1443703schnaps
schnozes2244493schnozes
science1138783science_
scions82612243scion__s
scoffed16266183scoffed
scoffer15317023scoffer
scoffers16286133scoffers
scoffs14347503sco_ffs
scolded11358863scolded
scolder103210343scolder
scolders11288993scolders
scolds95011233sco_lds
scolex1538243sco_lex
sconcheon1642373sconcheon
sconcheons1742093sconcheons
sconcing1338263sconcing
scooch13228123scooc_h
scooched16206683scooched
scooped124611743scooped
scooper113812033scooper
scoopers124210193scoopers
scoops105414363sco_ops
scootches1635003scootches
scooted103612283scooted
scooter93312873scooter
scooters103511033scooters
scoots85315943sco_ots
scope94821483sco_pe_
scoped115116653sco_ped
scops95820193sco__ps
scorch13198093scorc_h
scorched16187193scorched
scorcher15196783scorcher
scorchers16145513scorchers
score75526743sco_re_
scored94621133sco_red
scorer84818263sco_rer
scorers94115323scorers
scorned10229953scorned
scorner9259763scorner
scorners10228493scorners
scorns85713023sco_rns
scotch13207523scotc_h
scotched16187933scotched
scoter83815483sco_ter
scoters93313813scoters
scotias939753scotias
scots74025913sco__ts
scotties1039753scotties
scoured103811153scoured
scourer93910433scourer
scourers10348533scourers
scourges1136533scourges
scours84913593sco_urs
scouse84113633scouse_
scouted104112033scouted
scouter93313323scouter
scouters103411323scouters
scouths12527893scouths
scouts84817943sco_uts
scowder13286873scowder
scowders14276233scowders
scowed124413833sco_wed
scowled13398193scowled
scowler12248193scowler
scowlers13257373scowlers
scowls11549593sco_wls
scows106617803sco__ws
scrapes116217663scrapes
screes85023973sc_rees
scribes113713203scribes
scries85226823sc_ries
scrives124414273scrives
scrooches1645703scrooches
scrooges1137163scrooges
scrouges1136683scrouges
scrounges1243923scrounges
scrunches1635403scrunches
sculches15176273sculches
scunner9358243scunner
scunners10357303scunners
scutches15168883scutches
scutes85219193sc_utes
scuzzes1734403scuzzes
scythes15356523scythes
seance83716693seance_
seconals1047053seconals
seconde1037413seconde_
seconded1236353seconded
seconder1137183seconder
seconders1236953seconders
seconds1038283secon_ds
seduces1069283seduces
seines65029903sein_es
senores73218113senores
senses63923943s_enses
shines95028913shin_es
shocks154414583sho_cks
shoes85429663sho__es
shone83725983shon_e_
shoppes143411393shoppes
shores94830413sho_res
shotes95321913sho_tes
shoves124919423sho_ves
sices75637273s__ices
signees83510803signees
silences10310073silences
simonies10311113simonies
since75024173s_ince_
sines55954823s_in_es
singes74326853s_inges
skenes104616633sken_es
skoshes14246253skoshes
slices84022853s_lices
sloes54728873slo__es
slopes84820453slo_pes
sloshes103811803sloshes
slouches13208073slouches
sluices959073sluices
smocks145710013smo_cks
smokes124814343smo_kes
smooches15217263smooches
snoozes16289783snoozes
snores64324323sno_res
snyes85012753s__nyes
soaves94218673s_oaves
socages101012053socages
socas74026183s_o_cas
soccer1038543s_occer
soccers1138393s_occers
socks114926083s_o_cks
socles8418453s_ocles
sokes95031423s_o_kes
solaces93116133solaces
soles55547923s_o_les
solves95018223s_olves
sonances10310263sonances
sonars64818973s_onars
sonde64622833s_onde_
sonder73623523s_onder
sonders83820713s_onders
sone46649983s_on_e_
songs67725553s_on_gs
sonics84315633s_onics
sonless72612613s_onless
sonnet65923503s_onnet
sonnets74211993s_onnets
sonnies7315223sonnies
sons46049553s_on__s
sooner64220463soon_er
sooners73916643sooners
soonest7415593soon_est
soothes103917113soothes
sores55454283s_o_res
sources9312173sources
souses64229243s_ouses
spaces104722633s_paces
spancel1147363spancel
spancels1245273spancels
spence103813793spence_
spencer113610973spencer
spencers12269193spencers
spenses92913573spenses
spices104326033s_pices
spines85132033spin_es
splices113914383splices
spodes94817433spo_des
spokes124417213spo_kes
spondee10310593spondee
spondees1136483spondees
sponge939663sponge_
sponged1137953sponged
sponger1038523sponger
spongers1137603spongers
spoonies101911753spoonies
spores84726613spo_res
spouses92912813spouses
spruces113810503spruces
stance84316913stance_
stanches132312793stanches
stanes64933403stan_es
stenches132110293stenches
stocks124715633sto_cks
stodges9309083stodges
stogies8413693stogies
stoics8311113stoic_s
stokes104821793sto_kes
stoles63927673sto_les
stone55431183ston_e_
stoned75923143ston_ed
stoner65823203ston_er
stoners74817953stoners
stoney96217353ston_ey
stonier72013793stonier
stoniest8413543stoniest
stooges83611483stooges
stopes84525893sto_pes
stores65533663sto_res
stories7324273stories
stoures74614163stoures
stoves93818923sto_ves
swinges113413423swinges
syces106416463s__yces
sycoses1249133syco_ses
synced12266963s_ynced
synchs14408453s_ynchs
syncs104610173s_ync_s
tones56048663_ton_es
tonnes65320853_tonnes
toonies73719883toonies
trances93919643trances
trones65629283tron_es
trounces1037063trounces
usances967373usances
usaunces1073373usaunces
voces105918053_vo_ces
voices114414013_voices
winces114819113_winces
zones145528043_zon_es

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.423422437.4
2DLD Change Limit1340274856.01622278.4
3Display Results4854850.1563109.0
 (SQL Overall)1786914856.59527094.9
 
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.