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

217 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
applied124748(None) 
applier1137901applier
applies11311221applies
allied74217152a_llied
appalled1344812appalled
applaud1293902applaud
apple94517672appl_e_
apples104315762appl_es
applet105917432appl_et
appliers1235572appliers
appliqued2341952appliqued
apposed1247852apposed
apprised1337712apprised
apprized2236542apprized
dappled1336392dappl_ed
implied1238622implied
plied85118592__plied
reapplied1443682reapplied
replied103914462replied
supplied1345992supplied
unapplied1443742unapplied
uppiled12216592uppiled
abled86926833a_bl_ed
addled94112523addl_ed
aeried74221873a_eried
ailed66240283a_il_ed
aisled74516183aisl_ed
alibied1038143alibied
alien56425583a__lien
alined75221403a__lined
aliped95414283a__liped
allies63827673a_llies
ambled115116373ambl_ed
amped104820513amp__ed
ample94720303ampl_e_
ampler104313303ampl_er
amplified17115373amplified
amplify1744083amplify
aneled74719283anel_ed
angled84219093angl_ed
ankled114313483ankl_ed
anviled1138953anviled
aped78538153a_p__ed
apelike13310533apelike
aperies9423203aperies
aphid115515393a_phi_d
aplite8316393a_plite
aplites9314933a_plites
apparel1146003apparel
appealed1335603appealed
appeared1336143appeared
appeased1335793appeased
appel94615893app__el
appellee1246253appellee
append1138273app_end
appended1435483appended
applauded1542173applauded
applauds13103283applauds
applets115710063applets
applique2142583applique
appliques2242553appliques
apply125111393appl__y
applying1634653applying
appoint11612483appoint
appointed1444803appointed
appose10411993appose_
apposer1147483apposer
apposes11511473apposes
appraised1445593appraised
apprise11310193apprise
appriser1246783appriser
apprises12310963apprises
apprize2038183apprize
apprizer2145463apprizer
apprizes2137793apprizes
approved16115073approved
appulse1134673appulse_
appulses1234893appulses
aproned10311503aproned
argled85314553argl_ed
ariled75620323aril_ed
aspired1068173aspired
atelier7311643atelier
availed1135973availed
avulsed1133833avulsed
axled135315813a_xl_ed
belied95022163_belied
bellied104314073bellied
bullied104514813bullied
capped134721853capp__ed
collied103316683collied
complied1539683complied
copied114618573cop_ied
cullied104012353cullied
dallied93713613dallied
dapped124516763dapp__ed
dapple1138853dappl_e_
dapples1238993dappl_es
dappling1436843dappling
dollied93811143dollied
emptied1297403emptied
epoxied1734823epoxied
espied9359783esp_ied
flied96519433__flied
gallied94115003gallied
gapped124217123gapp__ed
gappier12369843gapp_ier
gillied95512313gillied
gipsied1135883gipsied
grappled14336093grappl_ed
gullied93812063gullied
gypsied1443273gypsied
happed144820103happ__ed
happened1635653happened
happier143312043happ_ier
hoppled15338083hoppl_ed
impled113812513impl_ed
implies11312123implies
jellied15419223jellied
jollied15349273jollied
lapeled10258893lapel_ed
lapelled11227083lapelled
lapped114320033lapp__ed
lappered13288213lappered
lappeted13255833lappeted
lied55838103___lied
lilied73913213_lilied
mapped134015883mapp__ed
misapplied1742763misapplied
napalmed1342503napalmed
napped114218163napp__ed
nappie104112263napp_ie_
nappier114411173napp_ier
nappies114613403napp_ies
nippled12307643nippl_ed
opposed1236123opposed
paled85538723_pal_ed
palier85023573_palier
palled94625163_palled
pallid93915293palli_d
pallier94417173pallier
palmed114314643_palmed
palped114513643_palped
palsied102911303palsied
pandied113913443pandied
panoplied1443423panoplied
papered122513173papered
pappier103511603pappier
pappies103214833pappies
parled94626293parl_ed
parried103615723parried
parslied1137823parslied
partied103516553partied
pelted94617763_pelted
pied75035373__p_ied
piled85232993_pil_ed
pilled94222753_pilled
pitied94017253_pitied
pled75231433__pl_ed
plie65127393__plie_
plier75221283__plier
plies74526513__plies
poled84934843_pol_ed
policed123212233_policed
polies84034583_polies
polled94022003_polled
ponied94920703_ponied
poppied11388993poppied
poppled11339243poppl_ed
preapplied1442703preapplied
pried84426863__pried
puled84926523_pul_ed
pulled94322193_pulled
pulped114612533_pulped
pulsed94013723_pulsed
rallied83514083rallied
rapped114122683rapp__ed
rappeled1335003rappeled
rappelled1443703rappelled
reapplies1344923reapplies
relied74926233_relied
repled93319783repl_ed
replier94214973replier
replies94521043replies
rippled123110273rippl_ed
ripplier1234463ripplier
sallied83316953sallied
sampled123410793sampl_ed
sapped114422013sapp__ed
sappier113613123sapp_ier
spalled103113133spalled
speiled104412123speiled
spelled103714743spelled
spied85427713_sp_ied
spiled94621993spil_ed
spilled103613623spilled
spliced124310593_spliced
splined105013113_splined
spoiled104811353spoiled
sullied83714483sullied
suppled1248463suppl_ed
supplier1246603supplier
supplies1268843supplies
tallied83314753tallied
tapped113820053tapp__ed
tippled12358393tippl_ed
toppled12348843toppl_ed
unpiled102312743unpiled
updried11226473updried
upped103715163upp__ed
uppile10178503uppile_
uppiles11208263uppiles
wapped144416473wapp__ed
willied114611563willied
yapped144415143yapp__ed
zapped204213523zapp__ed
zappier20458373zapp_ier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272176.70319995.1
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.18524870.0
 
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.