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

474 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
dunches13331258(None) 
bunches144116031bunches
dunces95215751dunc_es
hunches153913461hunches
lunches124115441lunches
munches144215791munches
punches144816131punches
benches143918602benches
brunches153710452brunches
bunched154312412bunched
butches144315362butches
cinches144215772cinches
conches144019812conches
crunches153711352crunches
culches143710742culches
curches143512742curches
cutches143216452cutches
dances95120652danc_es
ditches133215712ditches
douches134315232douches
drenches14309802drenches
duces86327472du_c_es
duchess1335552du_chess
duchies133312312du_chies
dunce86319262dunc_e_
dunch115316262dunch__
dunes65332172dun__es
dunites8313592dunites
finches153914192finches
glunches1436262glunches
gulches13398102gulches
haunches1656962haunches
hunched163710492hunched
hutches153613522hutches
inches114419672_inches
juncoes16338072juncoes
kenches163912272kenches
launches1387902launches
lunched133911822lunched
luncher123111412luncher
lunchers13349562lunchers
lurches123311662lurches
lynches15378872lynches
manches143818622manches
muches134718992mu_ches
mulches143210672mulches
munched153411072munched
muncher143610372muncher
munchers15318772munchers
munchies1539252munchies
mutches143314282mutches
nuncles939842nuncles
ouches114322182ou_ches
ounces83617772ounc_es
paunches1568172paunches
pinches144117932pinches
punched153512172punched
puncher143311672puncher
punchers152610072punchers
quenches2236012quenches
quiches2139332quiches
ranches123620112ranches
raunches1368052raunches
ruches114819582ru_ches
tenches123515522tenches
tusches1237902tusches
uncles8317162_uncles
wenches152914132wenches
winches154714372winches
aches106132293__aches
aduncous1143153aduncous
aitches123014363aitches
anchos114214893_anchos
apaches143411833apaches
arches114822043_arches
aunties73920073aunties
baches135426943_baches
batches144019613batches
beaches144120653beaches
bedunces1345513bedunc_es
beeches143413883beeches
belches143514343belches
benched154713943benched
bencher144113483bencher
benchers153611013benchers
birches143412323birches
bitches144117063bitches
blanches153311603blanches
blenches153310763blenches
boches134618523_boches
botches143716023botches
bounces113813683bounc_es
braches144621223braches
branches153613803branches
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
bunch125118603bunch__
bunchier1536153bunchier
bunchiest1635663bunchiest
bunchy16437463bunch_y
buncoed12378443buncoed
buncos104011593bunc_os
bundles103515773bundles
bungees104513103bungees
bungles104116763bungles
bunnies94415003bunnies
bushes115226113bu_shes
butcher143411163butcher
butchers153710183butchers
caches137926913_caches
canchas143212403canchas
catches144320763catches
chinches18369363chinches
churches1846433churches
cinched153910863cinched
clenches152910953clenches
cliches144213743cliches
clinches153910363clinches
cloches144113713cloches
clutches15307913clutches
coaches144018693coaches
conchas144013313conchas
conchies153214853conchies
conchos144313953conchos
conchs134714903conch_s
cooches143515833cooches
couches144020463couches
cranches153114543cranches
craunches1655723craunches
creches14313093creches
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crutches15359583crutches
cuishes122810823cuishes
cultches15316533cultches
daces85030683d_ac_es
dachas124113253d_achas
dance85223133danc_e_
danced105315253danc_ed
dancer94817613danc_er
dancers103413093dancers
dandies94121443dandies
dandles94218533dandles
dangles93618423dangles
danishes121710493danishes
dashes106124983d_ashes
datchas1347423datchas
deashes113313903deashes
deices94119373deic_es
denes65639723den__es
dengues938183dengues
denies74729643den_ies
denotes83817003denotes
denudes91510043denudes
detaches1439653detaches
deuces94015513deuc_es
dices86434243d_ic_es
dindles93817243dindles
dines66449153din__es
dinges83825423din_ges
dinghies1347363dinghies
dingies93618243dingies
dingles93818323dingles
dingoes94114823dingoes
dinkies123716033dinkies
dishes104622653d_ishes
ditched143711903ditched
ditcher134012003ditcher
ditchers143610363ditchers
donates83217223donates
donees74519493don_ees
dongles93212873dongles
donnees84210363donnees
douche124613223douche_
douched144012113douched
drachms1534253drachms
drenched15247913drenched
drencher14257213drencher
drenchers15296103drenchers
ducats95011763du_cats
duce76933503du_c_e_
duchy144310873du_ch_y
ducked144718013du_cked
ducker134317993du_cker
duckers143214713du_ckers
duckies143613813duckies
ducks124823213du_c_ks
ducted104012123du_cted
ducts85319893du_c_ts
dudes75424373du__des
duendes938193duendes
dues56045503du___es
duffles14308913duffles
dufuses11436593dufuses
dukes105023473du__kes
dulcet9314493dulc_et
dulcets1046283dulcets
dulses73913653du_lses
dummies123012133dummies
dunams937833dun_ams
duncish1335793duncish
dune56137583dun__e_
dunged95414693dun_ged
dungier9368583dungier
dungiest102810743dungiest
dungs75821973dun__gs
dunite7315013dunite_
dunked124315283dun_ked
dunker113616463dun_ker
dunkers123512193dunkers
dunks105621193dun__ks
dunlins849553dunlins
dunnages10154933dunnages
dunned85015523dun_ned
dunner73913823dun_ner
dunness8298983dunness
dunnest83312263dun_nest
dunnites947173dunnites
duns55140433dun___s
dunted84718503dun_ted
dunts65828413dun__ts
dupes86425933du__pes
durances1158683duranc_es
dures65635923du__res
durries83817353durries
dutch114713823dutch__
dutchmen1643163dutchmen
duties74921903du_ties
dynes95917583dyn__es
dynodes1235453dynodes
eches106322163__eches
educes94011953edu_c_es
etches114217763_etches
euchres1288663eu_chres
eunuchs1272683eunuch_s
fancies124018783fancies
fences114617113fenc_es
fetches153413893fetches
fiches145219533_fiches
filches153410723filches
fitches153516193fitches
fleches153411443fleches
flenches163410533flenches
flinches16358953flinches
frenches163311633frenches
fungoes11388813fungoes
funicles13246833funicles
funnies104113603funnies
ganaches1437413ganaches
glunched1544263glunched
gouaches1436193gouaches
grinches1436943grinches
grutches14285853grutches
gunites8313123gunites
gunnies83413123gunnies
gurshes112210033gurshes
gushes104719033gu_shes
hances115621283hanc_es
hatches153420273hatches
haunched1744813haunched
hitches153616273hitches
honchos15369573honchos
hooches153812523hooches
hotches153814363hotches
hunch136416213hunch__
hunkies143214503hunkies
hushes124718593hu_shes
hutched16359883hutched
inched124514483_inched
incher114114033_incher
inchers123912523_inchers
itches114916213_itches
jaunces16307423jaunc_es
jounces16369853jounc_es
juices1549423juic_es
juncos15449233junc_os
jungles154112543jungles
junkies183711693junkies
ketches164012193ketches
kuchen1536653ku_chen
kuchens1634713ku_chens
laches116528343_laches
lances84824103lanc_es
larches124416443larches
latches123320123latches
launces9329003launc_es
launched1475403launched
launcher1365563launcher
launchers1454333launchers
leaches123319343leaches
leches115421313_leches
leeches123911933leeches
letches124015483letches
liches114724293_liches
loaches123613983loaches
luces75528433lu_c_es
lucres84513303lu_cres
lunacies1038013lunacies
lunch104917243lunch__
luncheon1344013luncheon
luncheons1443603luncheons
lunes55337773lun__es
lungees84412143lungees
lunges76123423lun_ges
lunies64723013lun_ies
lunules738953lunules
lurched13358033lurched
lurcher12338133lurcher
lurchers13307153lurchers
lushes94022743lu_shes
lyches144213613_lyches
lynched16376753lynched
lyncher15366553lyncher
lynchers16285453lynchers
maches134827233_maches
manche133515103manche_
manchet143317773manchet
manchets15269573manchets
marches143921173marches
matches143219783matches
mensches1536283mensches
menshes12310443menshes
merches144013763merches
miches134320733_miches
minces104420803minc_es
mooches143714453mooches
mouches143815963mouches
mulched15307763mulched
munch124917103munch__
mungoes103510463mungoes
muscles11310563muscles
mushes114124563mu_shes
naches114622413_naches
nances83618643nanc_es
nancies93516843nancies
nautches1336073nautches
niches114419143_niches
nonces84418833nonc_es
notches123513653notches
nuances938523nuanc_es
nudzhes2032523nudzhes
nuncios937113nuncios
nuncle839363nuncle_
oraches124216473oraches
ouched124316933ou_ched
ounce77019933ounc_e_
ouphes113614633ou_phes
painches1588913painches
panaches15310283panaches
panoches1548123panoches
parches143720003parches
patches143320383patches
paunched1645523paunched
peaches144120053peaches
peduncles1443643peduncles
penoches1538933penoches
penuches1536943penuches
perches143717953perches
pinched153812453pinched
pincher143812713pincher
pinchers153510613pinchers
pitches143617753pitches
planches153111863planches
plenches153110623plenches
poaches144416943poaches
ponces104720843ponc_es
ponchos143410703ponchos
pooches143214163pooches
porches143815673porches
pouches144116743pouches
pounces114113893pounc_es
psyches1755803psyches
puces94924633pu_c_es
punch125118423punch__
puncheon1544473puncheon
puncheons1643913puncheons
punchier1536413punchier
punchiest1636453punchiest
punchless1643653punchless
punchy16398523punch_y
pungles104013713pungles
punishes1338113punishes
punkies134216803punkies
punties94520783punties
pushes114621663pu_shes
putsches1535313putsches
quaiches2235343quaiches
quashes192110973quashes
quenched2334103quenched
quencher2234123quencher
quenchers2343173quenchers
quiche2057903quiche_
quinces183210433quinc_es
quitches2236193quitches
qurshes19228573qurshes
rances84625443ranc_es
ranched133113603ranched
rancher123013633rancher
ranchers133311793ranchers
ranchos123911393ranchos
ratches123620463ratches
reaches123423203reaches
retches123318513retches
riches115022083_riches
roaches123616213roaches
rotches123515703rotches
rouches124217893rouches
ruche104216763ru_che_
ruched124314633ru_ched
rundles83214713rundles
runes55530223run__es
runkles114111943runkles
rushes94724363ru_shes
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
seiches12513813seiches
smutches15177273smutches
squinches2344253squinches
stanches132312793stanches
staunches1444603staunches
stenches132110293stenches
subniches1665143subniches
sucres84218893su_cres
sunchokes1864733sunchokes
sundaes8313093sundaes
synched16277213synched
synchs14408453synch_s
taches114224173_taches
teaches122718353teaches
torches123715433torches
touches125118343touches
tranches132915513tranches
trenches133512603trenches
troches123715343troches
tunes55332193tun__es
tunicles10217133tunicles
tunnies73614263tunnies
tusche1136783tusche_
tushes94319473tu_shes
uncages103213773_uncages
uncakes133012743_uncakes
uncaps1039813_uncaps
uncase83817433_uncase
uncases93516553_uncases
unchic1338643_unchic
unchokes17227273_unchokes
uncle7317053_uncle_
uncos74117033_unc_os
uncus74014983_unc_us
undies73821963_undies
undoes73917403_undoes
ungues7412123_ungues
unites65024853_unites
unshed10313773_unshed
unties64326923_unties
vetches153411263vetches
vouches153914113vouches
watches153017373watches
welches153710313welches
wenched163910913wenched
wencher153811133wencher
wenchers16319213wenchers
wiches144418753_wiches
winces114819113winc_es
winched163110593winched
wincher153410653wincher
winchers16319223winchers
witches152715793witches
wrenches163210233wrenches
wyches17387913_wyches
zilches21326303zilches

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.1401276364.3
2DLD Change Limit1340274746.59320328.7
3Display Results4744740.1862548.4
 (SQL Overall)1786914746.91925826.1
 
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.