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

220 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
recapped153594(None) 
becapped1733931becapped
remapped1534911remapped
capped134721852__capped
decamped1634962decamped
icecapped1841432icecapped
rapped114122682r__apped
reaped94122452re_a_ped
recalled11310802recalled
recaned102817202reca_ned
recanted112513512recanted
recarpet12310602recarpet
reclasped1444862reclasped
recopied1339842recopied
recouped13128662recouped
redipped1434782redipped
relapsed1136522relapsed
repped114616722re__pped
retaped103814282reta_ped
revamped1634142revamped
rewrapped1763022rewrapped
uncapped1556692uncapped
becalmed1534813becalmed
becarpet1447533becarpet
beclasped1643743beclasped
bewrapped1962513bewrapped
camped134720233__camped
caped104931803__ca_ped
capper124421983__capper
carped115923763__carped
chapped172711443_chapped
clapped143511173_clapped
copped135221253__copped
crapped143912623_crapped
cupped134413983__cupped
dapped124516763__dapped
decanted122310493decanted
decapod1335433deca_pod
decayed14309333deca_yed
decupled1494983decupled
dewlapped1841953dewlapped
elapsed1056103_elapsed
encamped1535023encamped
escaped12388853esca_ped
escarped1355163escarped
exapted1736073_exapted
flapped15328253_flapped
frapped15318853_frapped
gapped124217123__gapped
happed144820103__happed
heaped124516903he_a_ped
kepped15309543ke__pped
knapped16397103_knapped
kneecapped2151083kneecapped
lapped114320033__lapped
leaped94317773le_a_ped
mapped134015883__mapped
mudcapped1941383mudcapped
napped114218163__napped
pepped103113403pe__pped
petnapped1342383petnapped
prepped11329903pre__pped
pretaped13339133preta_ped
prewrapped1762163prewrapped
ramped114617903r__amped
raped85334623r__a_ped
rappee103618673r__appee
rappel104211953r__appel
rappen103512713r__appen
rapper104621573r__apper
rasped94715203r__asped
reached134619083re_ached
reacted103015713re_acted
readapted1344803readapted
readded103310733re_added
readied93316623re_adied
reamed94326123re_a_med
reaper84223143re_a_per
reappear1242623re_appear
reapplied1443673re_applied
reapply1434323re_apply
reared75930013re_a_red
rearmed103912823re_armed
reaved104523923re_a_ved
rebaited11410543rebaited
rebated103619703reba_ted
recaller1039323recaller
recamier1237603recamier
recane83022873reca_ne_
recanes93222263reca_nes
recanter101913153recanter
recap95718023reca_p__
recapping1636453recapping
recaps103615733reca_p_s
recaptured1573593recaptured
recarpeted1543703recarpeted
recarpets1344383recarpets
recarried1244983recarried
receded112713043rec_eded
receipted1445333receipted
received1437983received
recessed1139713recessed
rechanged1646853rechanged
recharged1656333recharged
recharted1557563recharted
rechewed1735633rechewed
recipe103414893rec_ipe_
recipes113314463rec_ipes
recited104319103rec_ited
recked134821803rec__ked
reckoned1546953reckoned
recladded1443673recladded
reclaimed1435543reclaimed
reclined113613603reclined
recoaled113111783recoaled
recoated113416783recoated
recocked17248473recocked
recoded113115033rec_oded
recoiled113613213recoiled
recoined113614423recoined
recombed1536713recombed
reconned113610653reconned
recooked15268243recooked
recopies12313733recopies
recorded122511063recorded
recorked15239853recorked
recoupe11109933recoupe_
recoupled1496163recoupled
recrated112918603recrated
recurred1137093recurred
recurved1436493recurved
recused104714423rec_used
recycled1634813recycled
redacted12410243redacted
redated93120923reda_ted
reearned948883reearned
refaced133713573refa_ced
regained102111243regained
regaled93615963rega_led
regarded11279803regarded
regauged1135143regauged
rehabbed1663713rehabbed
rehanged1357833rehanged
rehashed1536063rehashed
relaced103517213rela_ced
relanded102410463relanded
relapse947703relapse_
relapser1035273relapser
relapses1038033relapses
related83327573rela_ted
relaxed153312533rela_xed
relayed113212753rela_yed
remailed112411403remailed
remained112412893remained
remanded123011323remanded
remanned11319353remanned
remarked15209243remarked
remated103522473rema_ted
renailed92512803renailed
renamed103114523rena_med
repacked17188743repacked
repaired1148953repaired
repaper11310023repa_per
repapered1445233repapered
reparked15208923reparked
repassed11229273repassed
repasted112611533repasted
repaved133311133repa_ved
repled93319783re__pled
repumped1534383repumped
reracked15169123reracked
reraised9312353reraised
resailed93613063resailed
resampled1454113resampled
resawed113111183resa_wed
rescaled113311303resca_led
reshaped1437203reshaped
reshipped1753893reshipped
respaced1338503respaced
respaded1238133respaded
restamped1444433restamped
retacked15169273retacked
retagged1136063retagged
retailed94113963retailed
retained93016093retained
retape83917683reta_pe_
retapes93917423reta_pes
retarded102410753retarded
retasted92412113retasted
retaxed153512233reta_xed
retyped13367303re_typed
revalued1237023revalued
revamper1533533revamper
rewaked153811903rewa_ked
rewarded13229523rewarded
rewarmed14257433rewarmed
rewashed1546243rewashed
rewaxed18409343rewa_xed
ripped114419013r__ipped
riprapped1341973riprapped
sapped114422013__sapped
scalped124411993_scalped
scamped144711963_scamped
scaped115519553_sca_ped
scarped124314403_scarped
scrapped1556533scrapped
slapped123511843_slapped
snapped124611203_snapped
strapped1357823strapped
swapped15429143_swapped
tapped113820053__tapped
trapped124512213_trapped
unmapped1535173unmapped
untapped1376613untapped
wapped144416473__wapped
whapped18367573_whapped
wiretapped1851773wiretapped
wrapped15338023_wrapped
yapped144415143__yapped
zapped204213523__zapped

Search took 9 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.470380193.6
2DLD Change Limit1461622207.45319611.2
3Display Results2202200.0932365.6
 (SQL Overall)1786912208.01622291.8
 
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.