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

230 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
haunches165696(None) 
haunched1744811haunched
hunches153913461h_unches
launches1387901launches
paunches1568171paunches
raunches1368051raunches
brunches153710452brunches
bunches144116032_bunches
craunches1655722craunches
crunches153711352crunches
dunches133312582_dunches
glunches1436262glunches
hances115621282ha_nc_es
hatches153420272ha_tches
haunch14377342haunch__
hunched163710492h_unched
hutches153613522h_utches
jaunces16307422jaunc_es
launces9329002launc_es
launched1475402launched
launcher1365562launcher
launchers1454332launchers
lunches124115442_lunches
manches143818622ma_nches
munches144215792_munches
nautches1336082nautches
painches1588912painches
paunched1645522paunched
punches144816132_punches
ranches123620112ra_nches
staunches1444602staunches
aches106132293_a__ches
aitches123014363_aitches
anchos114214893_a_nchos
apaches143411843_apaches
arches114822043_a_rches
aunties73920073_aunties
babiches1735253babiches
baches135426943ba__ches
batches144019613ba_tches
benches143918603_benches
blanches153311603blanches
blenches153310763blenches
bounces113813683bounc_es
branches153613803branches
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
bunched154312413_bunched
butches144315363_butches
caches137926913ca__ches
caleches15269943caleches
caliches153812273caliches
canchas143212403ca_nchas
capuches1735513capuches
caroches15710693caroches
caruncles1345003caruncles
catches144320773ca_tches
chances145218093cha_nc_es
chancres15429363cha_ncres
chinches18369373chinches
churches1846433churches
cinches144215773_cinches
clenches152910953clenches
clinches153910363clinches
clutches15307923clutches
conches144019813_conches
couches144020473cou_ches
cranches153114543cranches
craunched1764023craunched
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crutches15359593crutches
culches143710743_culches
curches143512743_curches
cutches143216463_cutches
dances95120653da_nc_es
douches134315233dou_ches
drenches14309803drenches
dunces95215753_dunc_es
earaches13411313earaches
fancies124018783fa_ncies
fauces114916153fau_c_es
finches153914193_finches
flenches163410533flenches
flinches16358953flinches
frenches163311633frenches
ganaches1437433ganaches
gauche1238563gau_che_
gaucher1337243gau_cher
gauchest1436293gau_chest
gauchos1345903gau_chos
glunched1544263glunched
gouaches1436203gouaches
grinches1436953grinches
grutches14285853grutches
gulches13398113_gulches
halachas16317893halachas
hance105424153ha_nc_e_
handles114020653ha_ndles
hankies143617763ha_nkies
hanses95022633ha_n_ses
hantles104117513ha_ntles
hashes125024803ha__shes
hatched163414463ha_tched
hatchel153510753ha_tchel
hatchels16368673ha_tchels
hatcher153314723ha_tcher
hatchers163113173ha_tchers
hatchet153317563ha_tchet
hatchets163310383ha_tchets
haughs13408563hau_gh_s
haulages1236623haulages
haunted11399733haun_ted
haunter103111153haun_ter
haunters11329543haunters
haunts95614393haun__ts
hawfinches2451193hawfinches
headaches1845033headaches
heuchs14447923heu_ch_s
hitches153616273h_itches
honchos15369573h_onchos
hooches153812523h_ooches
hootches1656973hootches
hotches153814363h_otches
huaraches1744993huaraches
hunch136416213h_unch__
hunkies143214503h_unkies
hushes124718593h_u_shes
hutched16359883h_utched
inches114419673__inches
jaunce15367433jaunc_e_
jaunced17335473jaunc_ed
jounces16369853jounc_es
juncoes16338073_juncoes
kenches163912273_kenches
laches116528353la__ches
lances84824103la_nc_es
larches124416453la_rches
latches123320133la_tches
launce8469183launc_e_
launch11368063launch__
lunched133911823_lunched
luncher123111413_luncher
lunchers13349563_lunchers
lurches123311663_lurches
lynches15378873_lynches
maches134827233ma__ches
manche133515103ma_nche_
manchet143317783ma_nchet
manchets15269573ma_nchets
marches143921173ma_rches
matches143219783ma_tches
maundies1137853maundies
mouches143815963mou_ches
muches134718993_mu_ches
mulches143210673_mulches
munched153411073_munched
muncher143610373_muncher
munchers15318773_munchers
munchies1539253_munchies
mutches143314283_mutches
naches114622413na__ches
nances83618643na_nc_es
nancies93516843na_ncies
nuances938523nuanc_es
nuncles939843_nuncles
ouches114322183_ou_ches
ounces83617773_ounc_es
panaches15310293panaches
panoches1548123panoches
parches143720003pa_rches
patches143320383pa_tches
paunch13369853paunch__
paunchier1643333paunchier
paunchiest1743853paunchiest
paunchy17324443paunch_y
penuches1536943penuches
pinches144117933_pinches
planches153111863planches
plenches153110623plenches
pouches144116743pou_ches
pounces114113893pounc_es
punched153512173_punched
puncher143311673_puncher
punchers152610073_punchers
quaiches2235343quaiches
quenches2236013quenches
quiches2139333_quiches
rances84625443ra_nc_es
ranched133113603ra_nched
rancher123013633ra_ncher
ranchers133311793ra_nchers
ranchos123911393ra_nchos
ratches123620463ra_tches
raunch11358433raunch__
raunchier1443713raunchier
raunchiest1543933raunchiest
raunchy15284313raunch_y
relaunches1543443relaunches
rouches124217893rou_ches
ruches114819583_ru_ches
sauces84919503sau_c_es
sauchs115112233sau_ch_s
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
smutches15177273smutches
squinches2344253squinches
stanches132312793stanches
staunched1553473staunched
stauncher1443513stauncher
staunchest1543123staunchest
stenches132110293stenches
taches114224173ta__ches
tenches123515523_tenches
thatches1637513tha_tches
touches125118343tou_ches
tranches132915513tranches
trenches133512603trenches
tusches1237903_tusches
uncles8317163__uncles
usaunces1073373usaunc_es
vouches153914113vou_ches
watches153017373wa_tches
wauchts15285283wau_chts
wenches152914133_wenches
winches154714373_winches
wrenches163210233wrenches

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622307.34619896.8
3Display Results2302300.0932473.1
 (SQL Overall)1786912307.85922737.1
 
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.