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

117 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
pancaking183638(None) 
noncaking1646682noncaking
packing164420722pa_c_king
panicking1835292panicking
parbaking1877202parbaking
partaking1698672partaking
uncaking1539462_uncaking
anearing9413973_anearing
anticaking1747603_anticaking
antiking13412073_antiking
arcading1239763_arcading
arcking145811963_arc_king
awaking1547813_a_waking
backing165523443ba_c_king
bandaging1436063bandaging
banjaxing2642553banjaxing
banking144621353ban__king
caking134624673___caking
canakin131810833can_akin_
canakins142010463can_akins
canaling112016413can_aling
canceling14310163canceling
canvasing1546433canvasing
cascading1545673cascading
concaving1737353concaving
dancing113611563danc__ing
encaging1258733_encaging
encasing11610823_encasing
fancying1735353fanc_ying
hacking173720613ha_c_king
hangaring1438033hangaring
hanking154619103han__king
incaging1288673_incaging
incasing11610603_incasing
jacking214515263ja_c_king
kayaking1534063ka_yaking
knacking14296713knac_king
lacking143821543la_c_king
lancing103314123lanc__ing
lawmaking1943943lawmaking
manacling1446283manacling
managing1239093man_aging
manakin131810643man_akin_
manakins14209763man_akins
mandating1339773mandating
mapmaking2044623mapmaking
noncoking1646813noncoking
pacemaking2144383pacemaking
pacing114522753pa_c__ing
packaging1945163packaging
packings174310063pa_c_kings
paiking143814813pa__iking
painstaking1852853painstaking
palpating1438543palpating
pancake1536673pancak__e
pancaked1734893pancak_ed
pancakes1637073pancak_es
pandering133211963pandering
pandying15217663pan_dying
paneling111013633pan_eling
panelling1239093panelling
panfrying1842993panfrying
panging113319113pan__ging
pannikin14194923pannikin_
pannikins15204843pannikins
panning104019393pan__ning
panting104025423pan__ting
parading12313863pa_rading
parawing14310583pa_rawing
parceling1438443parceling
parching164313053parc_hing
parking143423043pa__rking
parlaying1537303parlaying
passaging1345613passaging
patching163212753patc_hing
peaking144317693p__eaking
pecking164017783p_ec_king
penciling1437413penciling
phreaking1936473phreaking
picking163418333p_ic_king
pinching163711053pinc_hing
pinking143918943pin__king
placating1438513placating
planking153513013plan__king
playmaking2243393playmaking
plucking17357723pluc_king
pocking163916763p_oc_king
poncing122913583ponc__ing
prancing132612163pranc__ing
pranking153813383pran__king
prebaking1838063prebaking
pricking173212603pric_king
punching163310123punc_hing
racking144323663ra_c_king
rainmaking1743973rainmaking
ranching141712043ranc_hing
ranking124320883ran__king
ransacking1744423ransacking
sacking144122703sa_c_king
sandaling112010563sandaling
snacking153411703snac_king
snaking123915303_sn_aking
sneaking133211093_sneaking
spanceling1543943spanceling
spanking153911973span__king
tacking144421483ta_c_king
talcking1567083talc_king
tanking123918793tan__king
uncaging1268713_uncaging
uncaring11312843_uncaring
uncasing11511003_uncasing
unmaking1538133_unmaking
vacating14310363va_cating
wanking154216783wan__king
yacking174315683ya_c_king
yanking154512463yan__king
zincking2435463zinc_king

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411176.83021763.0
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.29924481.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.