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

153 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
pancakes163707(None) 
pancake1536671pancake_
pancaked1734891pancaked
oatcakes1445542oatcakes
panaches15310292panaches
panchaxes2344452panchaxes
parbakes1638342parbakes
partakes1449922partakes
uncakes133012742_uncakes
alcades101011473_alcades
anankes1138763_anankes
ancones93116343_ancones
anlaces92313733_anlaces
anlages82414113_anlages
anlases72514903_anlases
annates72415423_annates
apanages1137013apan_ages
arcades101113193_arcades
ashcakes1753733ashcakes
awakes135012473_a_wakes
bandages12310633bandages
banjaxes2443393banjaxes
cakes116037673___cakes
canapes111213083can_apes
cancans11311873canca_ns
canvases13349523canvases
carcases12313093carcases
cascades13128553cascades
concaves1538913concaves
corncakes1745013corncakes
cupcakes1843713cupcakes
dances95120653danc__es
daycares1454803daycares
encages103313783_encages
encases93116053_encases
facades1339033fa_cades
fancies124018783fanc_ies
fanfares1436773fanfares
ganaches1437433ganaches
hances115621283hanc__es
handaxes1938403handaxes
hoecakes1745323hoecakes
hotcakes1744703hotcakes
incages103013883_incages
incases93615973_incases
intakes11310943_intakes
jacales16310323ja_cales
kanakas10327213kan_akas
lances84824103lanc__es
manacles1239523manacles
manages103418963man_ages
manches143818623manc_hes
mandates11314093mandates
mandrakes1646353mandrakes
nances83618643nanc__es
nancies93516843nanc_ies
oatcake1345363oatcake_
pacas96029403pa_ca__s
paces96741113pa_c__es
packages17138733packages
packed154822603pa_c_ked
packer144223403pa_c_ker
packers153818893pa_c_kers
packet144726503pa_c_ket
packets155114773pa_c_kets
packs135528933pa_c_k_s
painches1588913painc_hes
palaces114216463pa_laces
palates93624943pa_lates
palpates122613063palpates
panacea1137793pan_acea
panaceas1236763panaceas
panache1458433panache_
panadas103312213pan_adas
panamas113112763pan_amas
pancaking1836383pancaking
pancreas1235393pancreas
pancreases1443763pancreases
pandanus1136433pandanus
pandas95521963panda__s
pandies104224503pan_dies
pandores11312453pandores
panes76148693pan___es
panfries13149203panfries
pangas99921103panga__s
pangenes112612823pangenes
panicked1785173panicked
panicles121010113panicles
panmixes1934913panmixes
pannes85522853pan__nes
panoches1548123panoches
panpipes1135173panpipes
pansies94521983pan_sies
pantalet10415903pantalet
pantalets1147673pantalets
panties94230933pan_ties
pantiles103617153pantiles
pantries101817393pantries
papacies1439483papacies
parades104121463pa_rades
parbake1538353parbake_
parbaked1735503parbaked
parches143720003parc_hes
parkades1538273parkades
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakers1536563partakers
pascals11610013pasca_ls
passades1139203passades
passages1139513passages
patches143320383patc_hes
paunches1568173paunc_hes
pavanes123612653pa_vanes
pawnages1435313pawnages
paxwaxes1942053paxwaxes
penates93321603pen_ates
pennames12287793pennames
pentanes10316083pentanes
percales12313803percales
pikakes1245823p_ikakes
pinches144117933pinc_hes
pinnaces12268863pinnaces
pinwales1367963pinwales
placates12311753placates
planches153111863planc_hes
ponces104720843ponc__es
poundcakes19102133poundcakes
prances113618773pranc__es
prebakes1639013prebakes
punches144816133punc_hes
rances84625443ranc__es
ranches123620113ranc_hes
ranpikes1435643ranpikes
saccades13137253saccades
sanjaks1834963sanjak_s
snakes103919603_sn_akes
tankages13217113tankages
tannages9228963tannages
tannates81911953tannates
teacakes1435883teacakes
uncages103213773_uncages
uncake122813523_uncake_
uncaked143514353_uncaked
uncases93516553_uncases
unmakes132810793_unmakes
vacates12312833va_cates
vandykes1942163vandykes
vantages12119023vantages
wackes154717713wa_c_kes
wannabes1344473wannabes
wantages12109023wantages
zincates1937743zincates

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 Limit1461621537.30020022.2
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.79622920.9
 
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.