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

112 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
lappeted1325583(None) 
lappered13288211lappered
carpeted1338952carpeted
happened1635652happened
lanceted1137072lanceted
lapeled10258892la_peled
lapped114320032lapp__ed
lappet103817732lappet__
lappets11329132lappet_s
lippened13255222lippened
lippered13287952lippered
loppered13326752loppered
rappeled1335002rappeled
appealed1335603_appealed
appeared1336143_appeared
appeased1335793_appeased
append1138273_appe_nd
appended1435483_appended
appetent1248083_appetent
applied1247483_applied
apposed1247853_apposed
basseted1136753basseted
blanketed1643913blanketed
cacheted16148233cacheted
capered123014043ca_pered
capped134721853capp__ed
casketed1534953casketed
chapleted1743973chapleted
clapped143511173clapp__ed
competed154113593competed
coppered153410543coppered
dampened1435623dampened
dapped124516763dapp__ed
dapperer1335763dapperer
dappled1336393dapp_led
depleted12258723depleted
faceted13509563fa_ceted
flapped15328253flapp__ed
galleted1038223galleted
gapped124217123gapp__ed
garreted1057523garreted
hampered16239933hampered
happed144820103happ__ed
jacketed22146533jacketed
kippered17255623kippered
laagered1055853laagered
labeled102510563la_beled
labiated11109303labiated
lackered15108683lackered
lackeyed18104513lackeyed
lactated1138873lactated
laddered1136743laddered
ladened979053la_dened
lagered92311153la_gered
lakebed1434783la_kebed
lamented1138193lamented
lamped114017543lamp__ed
lanated8313203la_nated
lapelled11227083lapelled
lapidated1345673lapidated
lapper104319953lapp__er
lappers113717463lappe_rs
lapsed94712583la_p_sed
lariated91212063lariated
lasted74323603la__sted
lated65240673la___ted
latened8711923la_tened
lathered121512333lathered
laureated1096153laureated
laureled934543laureled
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
leafleted1342893leafleted
lipped114419543lipp__ed
lopped114218623lopp__ed
mapped134015883mapp__ed
marketed1537323marketed
napped114218163napp__ed
packeted17148283packeted
palleted1139873palleted
palpated13249763palpated
pampered15229233pampered
papered122513173pa_pered
parapeted1446483parapeted
pargeted1238683pargeted
paupered13216943paupered
peppered1236133peppered
rabbeted1334443rabbeted
racheted14149503racheted
racketed15169123racketed
rapiered1136053rapiered
rapped114122683rapp__ed
rappee103618673rappe_e_
rappees113611453rappe_es
rappelled1443703rappelled
sacheted14127833sacheted
sapped114422013sapp__ed
slapped123511853slapp__ed
slippered1434823slippered
tableted1137533tableted
tampered13279463tampered
tapered102612933ta_pered
tapped113820053tapp__ed
tappet103820113tappet__
tappets113610013tappet_s
targeted1037483targeted
valeted1139013va_leted
wapped144416473wapp__ed
yapped144415143yapp__ed
zapped204213523zapp__ed
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.453394461.4
2DLD Change Limit1461621127.20320291.8
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.70223200.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.