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

282 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
raunch1135843(None) 
craunch1464441craunch
haunch14377341haunch
launch11368061launch
paunch13369851paunch
ranch105019791ra_nch
raunchy15284311raunchy
branch134014782bra_nch
brunch13329352brunch
bunch125118602_bunch
cranch133613532cra_nch
crunch13349502crunch
dunch115316262_dunch
glunch1255352glunch
hunch136416212_hunch
jaunce15367432jaunce
launce8469182launce
lunch104917242_lunch
munch124917102_munch
nautch1144812nautch
painch133511322painch
paunchy17324442paunchy
punch125118422_punch
rance75028512ra_nce
rancho114310852ra_ncho
ratch104221362ra_tch
raunches1368052raunches
relaunch1352802relaunch
sauch104918772sau_ch
staunch1244272staunch
adunc837433adunc_
aitch105216163_aitch
ancho104515303_a_ncho
ankh111114413_a_nkh
arch98628443_a_rch
aunt46553653_aun_t
aunts55227633_aunts
aunty85919813_aunty
bach116131393ba__ch
banco94019393ba_nco
batch124620103ba_tch
bench125619503_bench
blanch133410853blanch
blench133710453blench
bounce104014833bounce
bouncy13409073bouncy
brach126123303bra__ch
branchy17357913bra_nchy
bunchy16437463_bunchy
bunco94616083_bunco
butch125416543_butch
cancha134411613ca_ncha
caroch13911763caroch
catch125120373ca_tch
chinch163911243chinch
church1636483church
cinch124516243_cinch
clench133910053clench
clinch133910353clinch
clutch13367753clutch
conch124620073_conch
couch125320113cou_ch
cratch134110793cra_tch
craunched1764023craunched
craunches1655723craunches
crouch133910203crou_ch
crunchy17324763crunchy
crutch13408243crutch
culch124512833_culch
curch124415413_curch
cutch125116193_cutch
dance85223133da_nce
daunt65929083daun_t
daunts75014083daunts
drench12369593drench
dunce86319263_dunce
dutch114713823_dutch
each95530583ea__ch
eunuch1154363_eunuch
fancy134615483fa_ncy
faugh125712963fau_gh
faun76226623faun__
fauna84816513faun_a
faunae95210373faunae
faunal94711593faunal
faunas94013633faunas
fauns84516753faun_s
finch135416973_finch
flench144010813flench
flinch144010103flinch
franc104615413fra_nc_
francs114112193fra_ncs
french143511213french
frounce1236153frounce
gauche1238563gau_che
gaucho1256223gau_cho
gaun56427713gaun__
gaunt65430403gaun_t
grinch1238483grinch
grouch12318473grou_ch
grutch12285563grutch
gulch113810603_gulch
hance105424153ha_nce
hatch135719593ha_tch
haugh125114053hau_gh
haunched1744813haunched
haunches1656963haunches
haunt85229133haun_t
haunts95614393haunts
heuch135312333heu_ch
hunh106323733_hun_h
hutch135414093_hutch
inch95420823__inch
jaunced17335473jaunced
jaunces16307423jaunces
jaunt125025273jaun_t
jaunts137511883jaunts
jaunty16388513jaunty
jounce153310733jounce
jouncy18336203jouncy
junco144612203_junco
kench145513923_kench
laich105920713la_ich
lance75126723la_nce
larch105919793la_rch
latch104620463la_tch
laugh94414373lau_gh
launces9329003launces
launched1475403launched
launcher1365563launcher
launches1387903launches
lurch104814633_lurch
lynch13468983_lynch
mach116134483ma__ch
manche133515103ma_nche
march125622893ma_rch
match125621103ma_tch
maun65727213maun__
maund85515453maun_d
maunds9519653maunds
maundy12506783maundy
mouch124715803mou_ch
much115224033_mu_ch
mulch124012973_mulch
mutch125016173_mutch
nance74721843na_nce
nancy105214923na_ncy
natch105018223na_tch
nuance859043nuance
orach105219233ora__ch
ouch95724633_ou_ch
ounce77019933_ounce
parch125123003pa_rch
patch125221223pa_tch
paunched1645523paunched
paunches1568173paunches
pinch125619303_pinch
planch133711443planch
plench134010813plench
pouch124617083pou_ch
pounce105214093pounce
prance104318573pra_nce
prelaunch1642153prelaunch
prelunch1543433prelunch
prepunch1743643prepunch
punchy16398523_punchy
quaich2047693quaich
quench2036633quench
rabic93817403rabic_
race66746263ra__ce
rack106234883ra__ck
racy95825683ra__cy
radish103516913radish
rah68052403ra___h
rain46251733rain__
rained75024603rained
rains55140233rain_s
rainy85921083rain_y
rajah155711423ra_jah
rakish134313963rakish
ralph1078743ra_lph
ran38266623ra_n__
rances84625443ra_nces
ranched133113603ra_nched
rancher123013633ra_ncher
ranches123620113ra_nches
ranchos123911393ra_nchos
rancid9513863ra_ncid
rancor8810373ra_ncor
rand55839573ra_n_d
rands65930453ra_nds
randy95022083ra_ndy
ranee55438103ra_nee
rang56939173ra_n_g
range64728423ra_nge
rangy95320393ra_ngy
rani46640113ra_n_i
ranid66429333ra_nid
ranis55235833ra_nis
rank85135533ra_n_k
ranks95225733ra_nks
rant45864683ra_n_t
rants55935343ra_nts
ranula6311813ranula
rash76039933ra__sh
rath76037663ra__th
raunchier1443713raunchier
raunchily1742823raunchily
ravish123414033ravish
rawish123012913rawish
rayah116013503ra_yah
reach105123883r_each
retch104818303r_etch
rhonchi1542503rhonchi
rich97025553r__ich
roach105717003r_oach
rotch105815933r_otch
rouche114714313rou_che
rough97819443rou_gh
round64318433roun_d
rounds73615623rounds
routh86423073rou_th
ruana5312423ruan_a
ruanas6311263ruanas
ruche104216763r_u_che
ruck104728333r_u_ck
run36244993r_un__
rune45236303r_un_e
runes55530223r_unes
rung56429983r_un_g
rungs611819403r_ungs
runic73615773r_unic
runny84613483r_unny
runs46438083r_un_s
runt46647993r_un_t
runts55927633r_unts
runty86119043r_unty
rush76628183r_u_sh
ruth76825993r_u_th
samech13277033samech
sangh95517463sa_ngh
sauce75121653sau_ce
sauchs115112233sau_chs
saucy104615163sau_cy
saugh95318403sau_gh
sauna54117553saun_a
saunas63915433saunas
scrunch1444033scrunch
sculch13226213sculch
scutch13247083scutch
smutch13205843smutch
squinch2134833squinch
stanch113812373stanch
stench114111163stench
such96424813_su_ch
synch135011793_synch
tach96132753ta__ch
taunt55532283taun_t
taunts65715663taunts
tench105620003_tench
teuch105214853teu_ch
touch106519393tou_ch
trance84718763tra_nce
tranche123312223tra_nche
trench114211613trench
trounce936823trounce
truancy1244993truancy
unci65019463__unci
unco66021403__unco
usaunce9103383usaunce
vaunt85925313vaun_t
vaunts95212623vaunts
vaunty12409063vaunty
vouch134611903vou_ch
watch135617063wa_tch
waucht14399413wau_cht
waugh125411683wau_gh
wench136214783_wench
winch135016663_winch
wrench14439353wrench
yucch15417433_yucch
yuch125818533_yu_ch

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.406440125.6
2DLD Change Limit1127162826.20318171.2
3Display Results2822820.0933032.3
 (SQL Overall)1786912826.70226662.3
 
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.