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

158 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
pancake153667(None) 
pancaked1734891pancaked
pancakes1637071pancakes
oatcake1345362oatcake
panache1458432panache
parbake1538352parbake
partake1339642partake
uncake122813522_uncake
alcade91111513_alcade
ananke1038283_ananke
ancone83916953_ancone
anlace82513923_anlace
anlage72514233_anlage
ansae55720973_ansa_e
ansate64517863_ansate
antae56828293_anta_e
apanage1036803apan_age
arcade91013643_arcade
arcane81216743_arcane
ashcake1663373ashcake
awake125014783_a_wake
baccae12119703bacca_e
baccate131011263baccate
bandage11311023bandage
cake105439963___cake
canape10913523can_ape
cancan10314103canca_n
cancans11311873cancans
carcase11312743carcase
cascade12118603cascade
concave1439373concave
corncake1645263corncake
cupcake1743953cupcake
dance85223133danc__e
daycare1355093daycare
encage93713503_encage
encase83714363_encase
facade1238803fa_cade
falcate12311623falcate
fanfare1336673fanfare
fanlike142610503fanlike
ganache1346223ganache
hance105424153hanc__e
hoecake1645203hoecake
hotcake1644543hotcake
incage93513623_incage
incase83615283_incase
intake10510863_intake
kanaka9357523kan_aka
lanate6421263lan_ate
lance75126723lanc__e
manacle11310283manacle
manage93818903man_age
manche133515103manc_he
mandate10315573mandate
mandrake1546003mandrake
manlike133012783manlike
manmade1237963manmade
nance74721843nanc__e
oatcakes1445543oatcakes
paca85132243pa_ca__
pacas96029403pa_ca_s
pace86345773pa_c__e
pack125535443pa_c_k_
package16128013package
packed154822603pa_c_ked
packer144223403pa_c_ker
packet144726503pa_c_ket
packs135528933pa_c_ks
palace104516923pa_lace
palate84226793pa_late
paleae84820293palea_e
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
panacea1137793panacea
panaches15310293panaches
panada94113053pan_ada
panama104213353pan_ama
pancaking1836383pancaking
panchax2134983panchax
panchaxes2344453panchaxes
panda85022613panda__
pandani1039903pandani
pandas95521963panda_s
pandore10411853pandore
pane64950293pan___e
panga85323543panga__
pangas99921113panga_s
pangene102711963pangene
panicked1785173panicked
panicky1833853panicky
panicle11129983panicle
panne76623653pan__ne
panoche1456383panoche
panpipe1034833panpipe
pantalet10415903pantalet
pantie84326473pan_tie
pantile93918483pantile
parade94720643pa_rade
parae76335703pa_ra_e
parbaked1735503parbaked
parbakes1638343parbakes
parkade1437583parkade
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
pascal10812373pasca_l
pascals11610013pascals
passade1039233passade
passage1039803passage
pavane114113443pa_vane
pawnage1335873pawnage
pence94924453penc__e
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentane9415743pentane
percale11314093percale
pikake11115803p_ikake
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
placate11312433placate
planate9314573plan_ate
planche14299753planc_he
plicae10410953plica_e
plicate11314513plicate
ponce95222513ponc__e
poundcake18101703poundcake
prance104318573pranc__e
prebake1539093prebake
punctate1246473punctate
rance75028513ranc__e
ranpike1335933ranpike
saccade12107033saccade
saccate111311763saccate
sanjak1735693sanjak_
sanjaks1834963sanjaks
snake94821113_sn_ake
tankage12257773tankage
tannage8209583tannage
tannate71813523tannate
teacake1335453teacake
unawake1445343unawake
uncage93014873_uncage
uncaked143514353_uncaked
uncakes133012743_uncakes
uncase83817433_uncase
unmake122811213_unmake
vacate11314553va_cate
vandyke1842513vandyke
vantage11109893vantage
wacke145918623wa_c_ke
wannabe1234533wannabe
wantage11119623wantage
zincate1838533zincate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271586.04622167.9
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.51527427.6
 
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.