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

268 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
haunch1437734(None) 
hunch136416211h_unch
launch11368061launch
paunch13369851paunch
raunch11358431raunch
brunch13329352brunch
bunch125118602_bunch
craunch1464442craunch
crunch13349502crunch
dunch115316262_dunch
glunch1255352glunch
hance105424152ha_nce
hatch135719592ha_tch
haugh125114052hau_gh
haunched1744812haunched
haunches1656962haunches
haunt85229132haun_t
haunts95614392haunts
heuch135312332heu_ch
hunh106323732h_un_h
hutch135414092h_utch
jaunce15367432jaunce
launce8469182launce
lunch104917242_lunch
munch124917102_munch
nautch1144812nautch
painch133511322painch
paunchy17324442paunchy
punch125118422_punch
ranch105019792ra_nch
raunchy15284312raunchy
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
branch134014773branch
bunchy16437463_bunchy
bunco94616083_bunco
butch125416543_butch
cancha134411613ca_ncha
caroch13911763caroch
catch125120373ca_tch
chance134617093cha_nce
chancy164010863cha_ncy
chaunt11613493chaun_t
chaunts1267083chaunts
chinch163911223chinch
church1636483church
cinch124516243_cinch
clench133910053clench
clinch133910353clinch
clutch13367753clutch
conch124620073_conch
couch125320113cou_ch
cranch133613533cranch
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
french143511213french
gauche1238553gau_che
gaucho1256223gau_cho
gaun56427713gaun__
gaunt65430403gaun_t
grinch1238473grinch
grutch12285563grutch
gulch113810603_gulch
hack135134543ha__ck
hadith13312063hadith
haen76229453haen__
hah910655223ha___h
haint85436323hain_t
haints94417583haints
halacha15388003halacha
hallah124115403hallah
halvah15499833halvah
hamzah23135553hamzah
hances115621283ha_nces
hand86833703ha_n_d
hands95327383ha_nds
handy125520873ha_ndy
hang85535543ha_n_g
hangs95726723ha_ngs
hank115134133ha_n_k
hanks126226863ha_nks
hanky155418293ha_nky
hansa85416783ha_nsa
hanse85722793ha_nse
hant75461583ha_n_t
hants86335403ha_nts
harsh116418053ha_rsh
harumph1742933harumph
hash106936503ha__sh
hath105933913ha__th
haughs13408563haughs
haul75530453hau__l
hauled104415213hauled
hauler95015123hauler
haulm104415413hau_lm
haulms11558503haulms
haulmy14455553haulmy
hauls86123733hau_ls
haunted11399733haunted
haunter103111153haunter
hausen9610383hausen
haut75949733hau__t
haute89521613hau_te
havoc1337183havoc_
havocs1435653havocs
hawfinch2242033hawfinch
hence104920043h_ence
heuchs14447923heu_chs
heugh125410923heu_gh
hitch134515473h_itch
honcho14389383h_oncho
hooch135813703h_ooch
hootch14386403hootch
hotch136214723h_otch
houdah1335173houdah
hound95016483houn_d
hounds104413133hounds
huck135927633h_u_ck
huh96432013h_u__h
huic94818053h_uic_
humph155712213h_umph
hun65844713h_un__
hunched163710493h_unched
hunches153913463h_unches
hung86126353h_un_g
hunk116029543h_un_k
hunks125321453h_unks
hunky155417733h_unky
huns76136933h_un_s
hunt76445493h_un_t
hunts86826173h_unts
hush105224113h_u_sh
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
mach116134473ma__ch
manche133515103ma_nche
march125622893ma_rch
match125621103ma_tch
maun65727203maun__
maund85515443maun_d
maunds9519653maunds
maundy12506783maundy
mouch124715803mou_ch
much115224033_mu_ch
mulch124012973_mulch
mutch125016173_mutch
nance74721843na_nce
nancy105214923na_ncy
natch105018223na_tch
nuance859043nuance
ouch95724633_ou_ch
ounce77019933_ounce
parch125123003pa_rch
patch125221223pa_tch
paunched1645523paunched
paunches1568173paunches
pinch125619303_pinch
planch133711443planch
plench134010813plench
pouch124617083pou_ch
pounce105214093pounce
punchy16398523_punchy
quaich2047693quaich
quench2036633quench
rance75028513ra_nce
rancho114310853ra_ncho
ratch104221363ra_tch
raunches1368053raunches
relaunch1352803relaunch
samech13277033samech
sangh95517453sa_ngh
sauce75121653sau_ce
sauchs115112233sau_chs
saucy104615163sau_cy
saugh95318403sau_gh
sauna54117553saun_a
saunas63915433saunas
scrunch1444033scrunch
sculch13226213sculch
scutch13247083scutch
shaugh13287433shau_gh
sheuch14267043sheu_ch
smutch13205843smutch
squinch2134833squinch
stanch113812373stanch
stench114111163stench
such96424813_su_ch
synch135011793_synch
tach96132753ta__ch
taunt55532283taun_t
taunts65715663taunts
tench105620003_tench
teuch105214853teu_ch
thatch1435603tha_tch
touch106519393tou_ch
trench114211613trench
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.1401276364.3
2DLD Change Limit1127162686.23318083.7
3Display Results2682680.0803350.0
 (SQL Overall)1786912686.45327691.2
 
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.