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

264 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
panaches1531029(None) 
ganaches1437431ganaches
panache1458431panache_
panoches1548121panoches
apaches143411842_apaches
earaches13411312earaches
ganache1346222ganache_
manacles1239522manacles
manches143818622man_ches
naches114622412__naches
painches1588912painches
palaces114216462palac_es
panacea1137792panac_ea
panaceas1236762panaceas
pancakes1637072pancakes
panicles121010112panicles
panochas1545652panochas
panoche1456382panoche_
papacies1439482papacies
parches143720002pa_rches
patches143320382pa_tches
paunches1568172paunches
peaches144120052p_eaches
penoches1538932penoches
penuches1536942penuches
pinches144117932pin_ches
planches153111862plan_ches
pleaches153210432pleaches
poaches144416942p_oaches
preaches153214892preaches
punches144816132pun_ches
ranches123620112ran_ches
spinaches1645272spinaches
abashes12510373_abashes
aches106132293___aches
aitches123014363_aitches
anankes1138763_anankes
anarchies1448183_anarchies
anarchs1237093_anarch_s
anchos114214893_an_chos
anlaces92313733_anlac_es
apache134210783_apache_
apanages1137013apana_ges
arches114822043_a_rches
attaches13137723attaches
babiches1735253babiches
baches135426943__baches
backaches22146813backaches
banishes131812463banishes
barnacles1355333barnacles
batches144019613ba_tches
beaches144120653_beaches
benches143918603ben_ches
blanches153311603blan_ches
bleaches153410673bleaches
braches144621223_braches
branches153613803bran_ches
breaches153714123breaches
broaches153211623broaches
bunches144116033bun_ches
caches137926913__caches
calashes13310543calashes
caleches15269943caleches
caliches153812273caliches
canapes111213083cana_pes
canaries10318943canaries
canchas143212403can_chas
capuches1735513capuches
caroaches1637793caroaches
caroches15710693caroches
catches144320773ca_tches
cenacles1238023cenacles
cinches144215773cin_ches
coaches144018693_coaches
conches144019813con_ches
cranches153114543cran_ches
dances95120653dan_c_es
danishes121710493danishes
detaches1439653detaches
dunches133312583dun_ches
earache1239333earache_
fancies124018783fan_cies
finches153914193fin_ches
gamashes1456953gamashes
gnashes11419573_gnashes
gouaches1436203gouaches
halachas16317893halachas
hances115621283han_c_es
hatches153420273ha_tches
haunches1656963haunches
headaches1845033headaches
huaraches1744993huaraches
hunches153913463hun_ches
inarches1358043inarches
inches114419673_in_ches
kenches163912273ken_ches
laches116528353__laches
lances84824103lan_c_es
larches124416453la_rches
latches123320133la_tches
launches1387903launches
lavashes1445573lavashes
leaches123319343_leaches
loaches123613983_loaches
lunacies1038013lunacies
lunches124115443lun_ches
lynches15378873lyn_ches
maches134827233__maches
manacle11310283manacle_
manacled1336453manacled
manages103418963mana_ges
manatees10310423manatees
manche133515103man_che_
manchet143317783man_chet
manchets15269573man_chets
marches143921173ma_rches
matches143219783ma_tches
menaces112715523menac_es
menarches1646683menarches
mensches1536303mensches
munches144215793mun_ches
nachas114914193__nachas
nachos115014183__nachos
nacres85614453__nacres
nances83618643nan_c_es
nancies93516843nan_cies
nautches1336083nautches
niches114419143__niches
oraches124216473_oraches
paces96741113p__ac_es
pachas135017143p__achas
palace104516923palac_e_
palaced124110783palac_ed
palates93624943pala_tes
panacean1244733panacean
panadas103312213pana_das
panamas113112763pana_mas
pancake1536673pancake_
pancaked1734893pancaked
panchax2134983pan_chax
panchaxes2344453pan_chaxes
pancreas1235393pan_creas
pandies104224503pan_dies
pandores11312453pandores
panes76148693pan___es
panfishes1737593panfishes
panfries13149203panfries
pangenes112612823pangenes
panicked1785173panicked
panicle11129983panicle_
panicled13106783panicled
panics103815363panic__s
panicums1444743panicums
panmixes1934913panmixes
pannes85522853pan__nes
panocha1444983panoch_a
panpipes1135173panpipes
pansies94521983pan_sies
panther12611443pan_ther
panthers13510783pan_thers
panties94230933pan_ties
pantiles103617153pantiles
pantries101817393pantries
parables121613563parables
parachor1546663parachor
parachors1647413parachors
parachutes1744153parachutes
parades104121463para_des
paraphs1439313paraph_s
parched154013693pa_rched
parchesi15358213pa_rchesi
parishes13314753parishes
pashes115828393p__ashes
pastiches1637453pastiches
patacas11311003patac_as
patched153514623pa_tched
patcher143515143pa_tcher
patchers153413303pa_tchers
paunched1645523paunched
pavanes123612653pava_nes
pawnages1435313pawna_ges
payables15166483payables
pazazzes1752343pazazzes
peaces106324083p_eac_es
peached154315883p_eached
peacher144216073p_eacher
peachers153213843p_eachers
penances12312443penances
penates93321603pena_tes
penoche1447043penoche_
pentacles1338773pentacles
penuche1435943penuche_
penuchis1544283penuchis
penuchles1643763penuchles
perches143717953p_erches
picachos1744523picachos
pinched153812453pin_ched
pincher143812713pin_cher
pinchers153510613pin_chers
pinnaces12268863pinnac_es
pinnacles13276043pinnacles
pinochles1644863pinochles
pinocles1248693pinocles
pinscher1544813pinscher
pinschers1644383pinschers
piracies12312643piracies
pistaches1646673pistaches
pitches143617753p_itches
places104323703p_lac_es
planche14299753plan_che_
planchet152511963plan_chet
planchets16236743plan_chets
planishes14138523planishes
plashes124417393p_lashes
pleached16338063pleached
plenches153110623plenches
poached154212403p_oached
poacher143912323p_oacher
poachers152910763p_oachers
pomaces132712123pomac_es
ponces104720843pon_c_es
ponchos143410703pon_chos
pooches143214163p_ooches
porches143815673p_orches
potashes1337833potashes
potiches1539203potiches
potlaches16115263potlaches
pouches144116743p_ouches
prances113618773pran_c_es
preached163412063preached
preacher153211373preacher
preachers16339573preachers
psyches1755803p_syches
punched153512173pun_ched
puncher143311673pun_cher
punchers152610073pun_chers
punishes1338113punishes
putsches1535313putsches
rances84625443ran_c_es
ranched133113603ran_ched
rancher123013633ran_cher
ranchers133311793ran_chers
ranchos123911393ran_chos
ratches123620463ra_tches
raunches1368053raunches
reaches123423203_reaches
roaches123616213_roaches
sanicles10149943sanicles
shanachies1844273shanachies
snashes105214753_snashes
snatches131410713snatches
snathes104816493_snathes
stanches132312793stan_ches
taches114224173__taches
takahes1436173taka_hes
teaches122718353_teaches
tenaces92814513tenac_es
tenches123515523ten_ches
tranches132915513tran_ches
upreaches1654633upreaches
vanishes141610753vanishes
watches153017373wa_tches
wenches152914133wen_ches
winches154714373win_ches

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.436409841.7
2DLD Change Limit1461622647.08020644.4
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.62623431.8
 
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.