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

137 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
dapperer133576(None) 
caperer113013402ca_perer
dampener1335532dampener
dapper114016632dapp__er
dapperest1445282dapperest
dapperly1643002dapperly
hamperer15379092hamperer
kipperer16294722kipperer
lappered13288212lappered
pamperer14228332pamperer
paperer113111902pa_perer
pepperer1145282pepperer
tamperer12248892tamperer
taperer92511792ta_perer
adherer1137573_adherer
alterer72713993_alterer
ampere10514413_ampere_
amperes11313983_amperes
apparel1146003_apparel
appealer1245743_appealer
appear10379343_appe_ar
appeared1336143_appeared
appeaser1245953_appeaser
applier1137903_applier
apposer1147483_apposer
asperser10408303_asperser
aspirer967903_aspirer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
capered123014043ca_pered
caperers122611723ca_perers
capper124421983capp__er
cappers134419403capper_s
capturer1246093capturer
careerer1038583careerer
caterer92815943ca_terer
cipherer1545573cipherer
coppered153410543coppered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
damneder1243763damneder
dampened1435623dampened
dampeners1444663dampeners
damper114117753damp__er
dampers123915693damper_s
dandered112110963dandered
dangered11248513dangered
dapped124516763dapp__ed
dapperness1543153dapperness
dapple1138853dapp_le_
dappled1336393dapp_led
dapples1238993dapp_les
darer65230793da___rer
darkener1335993darkener
darneder1033983darneder
deepener1145183deepener
depleter11298863depleter
deplorer1136343deplorer
diapered1238003diapered
diplexer1844213diplexer
dipper114017793dipp__er
dippers123615183dipper_s
dippier123111393dipp_ier
disperser12109083disperser
ditherer12187763ditherer
dodderer1144203dodderer
duplexer1842903duplexer
eagerer8248823ea_gerer
falterer11239853falterer
gappier12369843gapp_ier
gatherer12147903gatherer
hammerer15278143hammerer
hampered16239933hampered
hamperers16287533hamperers
hankerer15248233hankerer
happened1635653happened
happier143312033happ_ier
jabberer1944023jabberer
kippered17255623kippered
kipperers17233823kipperers
lapper104319953lapp__er
lappers113717463lapper_s
lappeted13255833lappeted
latherer111310443latherer
lippered13287953lippered
loppered13326753loppered
mapper124516093mapp__er
mappers133313783mapper_s
napper103718283napp__er
nappers114214863napper_s
nappier114411173napp_ier
palterer102411273palterer
pampered15229233pampered
pamperers15236863pamperers
panderer112210913panderer
papered122513173pa_pered
paperers122410453pa_perers
pappier103511593papp_ier
patterer103112173patterer
paupered13216943paupered
peppered1236133peppered
pepperers1244903pepperers
properer1259203properer
rapiered1136053rapiered
rapparee1245873rapparee
rappee103618673rappe_e_
rappees113611453rappe_es
rappeled1335003rappeled
rapper104621573rapp__er
rappers113618443rapper_s
sapper103822353sapp__er
sappers113518903sapper_s
sappier113613113sapp_ier
scamperer1544623scamperer
simperer1237173simperer
tampered13279463tampered
tamperers13227313tamperers
tapered102612933ta_pered
taperers10269773ta_perers
tapper104419613tapp__er
tappers113416543tapper_s
temperer12227723temperer
vaporer1236983va_porer
vapourer1344263vapourer
wagerer11328493wa_gerer
wanderer122210123wanderer
waterer103314073wa_terer
waverer13319523wa_verer
yammerer15225483yammerer
yapper133714513yapp__er
yappers144012253yapper_s
zapper193414023zapp__er
zappers203911633zapper_s
zappier20458373zapp_ier
zippered22244823zippered

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.610292936.1
2DLD Change Limit1461621376.95321021.4
3Display Results1371370.0602283.3
 (SQL Overall)1786911377.62323441.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.