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

212 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
panoches154812(None) 
panaches15310281panaches
panochas1545651panochas
panoche1456381panoche_
penoches1538931penoches
caroches15710692caroches
ganaches1437412ganaches
manches143818622man_ches
painches1588912painches
panache1458422panache_
panicles121010112panicles
panocha1444982panoch_a
parches143720002pa_rches
patches143320382pa_tches
paunches1568172paunches
penoche1447042penoche_
penuches1536942penuches
pinches144117932pin_ches
pinochles1644862pinochles
pinocles1248692pinocles
planches153111862plan_ches
pooches143214162p_ooches
punches144816132pun_ches
ranches123620112ran_ches
aches106132293_a__ches
aitches123014363_aitches
anchos114214893_an_chos
ancones93116343_ancones
anodes74418753_ano_des
anoles64827423_ano_les
anomies93316993_anomies
another10289153_another
apaches143411833_apaches
arches114822043_a_rches
avouches1634823_avouches
babiches1735253babiches
baches135426943ba__ches
banishes131812463banishes
barouches1644973barouches
batches144019613ba_tches
benches143918603ben_ches
binocles1236413binocles
blanches153311603blan_ches
boches134618523__boches
branches153613803bran_ches
brioches15227253brioches
brooches15288193brooches
bunches144116033bun_ches
caboched1844043caboched
caches137926913ca__ches
caleches15269933caleches
caliches153812263caliches
canchas143212403can_chas
canoes84725883cano__es
canopies12311853canopies
capouches1843633capouches
capuches1735513capuches
caroaches1637793caroaches
caroche1469243caroche_
carroches1665893carroches
catches144320773ca_tches
cinches144215773cin_ches
cloches144113713_cloches
conches144019813con_ches
cooches143515833_cooches
cranches153114543cran_ches
dances95120653dan_c_es
danishes121710493danishes
dunches133312583dun_ches
earaches13411303earaches
fancies124018783fan_cies
finches153914193fin_ches
galoshes1236893galoshes
ganache1346203ganache_
hances115621283han_c_es
hatches153420273ha_tches
haunches1656963haunches
hooches153812523_hooches
hunches153913463hun_ches
inarches1358043inarches
inches114419673_in_ches
kenches163912273ken_ches
laches116528343la__ches
lances84824103lan_c_es
larches124416443la_rches
latches123320123la_tches
launches1387903launches
lunches124115443lun_ches
lynches15378873lyn_ches
maches134827233ma__ches
manacles1239523manacles
manche133515103man_che_
manchet143317773man_chet
manchets15269573man_chets
marches143921173ma_rches
matches143219783ma_tches
mensches1536293mensches
monocles12310673monocles
mooches143714453_mooches
munches144215793mun_ches
naches114622413__naches
nances83618643nan_c_es
nancies93516843nan_cies
nautches1336083nautches
niches114419143__niches
noshes96618233__noshes
notches123513653__notches
paces96741113pa__c_es
pachas135017143pa__chas
pahoehoes1752253pahoehoes
palaces114216453palac_es
panacea1137783panac_ea
panaceas1236763panaceas
pancakes1637073pancakes
panchax2134983pan_chax
panchaxes2344453pan_chaxes
pancreas1235393pan_creas
pandies104224503pan_dies
pandores11312453pandores
panes76148693pan___es
panfishes1737593panfishes
panfries13149203panfries
pangenes112612823pangenes
panicked1785173panicked
panicle11129983panicle_
panicled13106783panicled
panics103815363panic__s
panicums1444743panicums
panmixes1934913panmixes
pannes85522853pan__nes
panoplies1346003panoplies
panpipes1135173panpipes
pansies94521983pan_sies
pansophies1774193pansophies
panther12611443pan_ther
panthers13510783pan_thers
panties94230933pan_ties
pantiles103617153pantiles
pantofles1474863pantofles
pantries101817393pantries
papacies1439473papacies
papooses1248053papooses
parched154013693pa_rched
parchesi15358213pa_rchesi
parishes13314753parishes
parodies11313693parodies
parolees104313973parolees
paroles95025883paro_les
pashes115828393pa__shes
pastiches1637453pastiches
patched153514623pa_tched
patcher143515143pa_tcher
patchers153413303pa_tchers
paunched1645523paunched
peaches144120053p_eaches
penuche1435943penuche_
penuchis1544283penuchis
penuchles1643763penuchles
perches143717953p_erches
pinched153812453pin_ched
pincher143812713pin_cher
pinchers153510613pin_chers
pinochle1544743pinochle
pinocle1138143pinocle_
pinoles93418703pino_les
pinones94717073pino_nes
pinscher1544803pinscher
pinschers1644373pinschers
pitches143617753p_itches
planche14299753plan_che_
planchet152511963plan_chet
planchets16236743plan_chets
planishes14138523planishes
pleaches153210433pleaches
plenches153110623plenches
poaches144416943p_oaches
ponces104720843pon_c_es
ponchos143410703pon_chos
pooched152810083p_ooched
porches143815673p_orches
potiches1539203potiches
pouches144116743p_ouches
prances113618773pran_c_es
preaches153214893preaches
psyches1755803p_syches
punched153512173pun_ched
puncher143311673pun_cher
punchers152610073pun_chers
punishes1338113punishes
putsches1535313putsches
rances84625443ran_c_es
ranched133113603ran_ched
rancher123013633ran_cher
ranchers133311793ran_chers
ranchos123911393ran_chos
ratches123620463ra_tches
raunches1368053raunches
sanicles10149943sanicles
scooches15188413scooches
smooches15217263smooches
snatches131410713snatches
soroches1338803soroches
spinaches1645273spinaches
stanches132312793stan_ches
taches114224173ta__ches
tenches123515523ten_ches
tranches132915513tran_ches
troches123715343_troches
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.1561145455.1
2DLD Change Limit1461622127.11020557.2
3Display Results2122120.0932279.6
 (SQL Overall)1786912127.35924282.0
 
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.