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

196 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
recapping163645(None) 
becapping1834241becapping
remapping1635021remapping
capping143819672__capping
decamping1734942decamping
rapping123619102r__apping
reaping103621212re_a_ping
recalling122211902recalling
recaning111416692reca_ning
recanting122414822recanting
recasting122414232recasting
reclasping15105082reclasping
recopying1737112recopying
recouping1438362recouping
redipping1555592redipping
relapsing1236842relapsing
repping123314982re__pping
retaping113012552reta_ping
revamping1734632revamping
rewrapping1843342rewrapping
uncapping1635132uncapping
becalming1635283becalming
beclasping17134073beclasping
bewrapping2042493bewrapping
camping143118973__camping
cappings15369493__cappings
carping123521083__carping
chapping183710723_chapping
clapping153810603_clapping
copping143918593__copping
crapping153911453_crapping
cupping144312383__cupping
dapping133714793__dapping
decanting132510633decanting
decaying15239453deca_ying
decupling1534973decupling
elapsing1146713_elapsing
encamping1645233encamping
escaping1347063esca_ping
escarping1435203escarping
flapping16298153_flapping
frapping16348103_frapping
gapping134214783__gapping
happing153817233__happing
heaping133015853he_a_ping
kepping16268593ke__pping
knapping17314973_knapping
kneecapping225973kneecapping
lapping124117023__lapping
leaping103215993le_a_ping
mapping143413993__mapping
mudcapping2041413mudcapping
napping123514183__napping
pepping113511623pe__pping
petnapping1442303petnapping
precasting15169833precasting
prepping12309763pre__pping
pretaping1439133preta_ping
prewrapping1842393prewrapping
ramping123316873r__amping
raping94829853r__a_ping
rappini11347573r__appini
rasping104316253r__asping
reaching143317203re_aching
reacting113317893re_acting
readapting1445153readapting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
reaming103924013re_a_ming
reapplying1843023re_applying
reappoint1346323re_appoint
rearing83128783re_a_ring
rearming111413613re_arming
reaving113820533re_a_ving
rebaiting12311643rebaiting
rebating112418343reba_ting
recapped1535943recapp_ed
recapturing1643763recapturing
recarpeting1674363recarpeting
recarrying1643653recarrying
receding122713763rec_eding
receipting1546753receipting
receiving1538993receiving
recessing12611013recessing
rechanging1746043rechanging
recharging1745293recharging
recharting1637213recharting
rechewing1836493rechewing
reciting113118073rec_iting
recking144319923rec__king
reckoning1637643reckoning
recladding1543973recladding
reclaiming1546583reclaiming
reclining121112283reclining
recoaling121312453recoaling
recoating121317463recoating
recocking18138373recocking
recoding122213853rec_oding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recording131311623recording
recorking16149643recorking
recoupling1545043recoupling
recrating121318793recrating
recurring1237953recurring
recurving1536773recurving
recusing112512883rec_using
recutting1239483recutting
recycling1734903recycling
redacting13612303redacting
redating102620173reda_ting
reearning1039053reearning
refacing142512813refa_cing
refalling132010423refalling
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
rehabbing1733653rehabbing
rehanging1437563rehanging
rehashing1647113rehashing
relacing112516043rela_cing
relanding112110923relanding
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remarking1638893remarking
remating112322413rema_ting
renailing102813333renailing
renaming11313693rena_ming
repacking1838283repacking
repairing12310013repairing
repapering1547043repapering
reparking1638923reparking
repassing12249423repassing
repasting122312843repasting
repaving142810743repa_ving
repaying142712393repa_ying
repumping1634813repumping
reracking1639313reracking
reraising10313773reraising
resailing103314253resailing
resampling1544333resampling
resawing122311433resa_wing
resaying122512453resa_ying
rescaling122212013resca_ling
reshaping1557743reshaping
reshipping1843793reshipping
respacing1438893respacing
respading1338803respading
respring111614063re_spring
restamping1565213restamping
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retaining102114733retaining
retaking133114283reta_king
retarding111110653retarding
retasting102513413retasting
retaxing162311333reta_xing
retyping14255613re_typing
revaluing1337303revaluing
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
ripping123315743r__ipping
riprapping1452083riprapping
sapping123519313__sapping
scalping133410453_scalping
scamping153510193_scamping
scaping123715693_sca_ping
scarping133312463_scarping
scrapping1635743scrapping
slapping133510833_slapping
snapping13349653_snapping
strapping1436993strapping
swapping16348673_swapping
tapping123317133__tapping
trapping132911393_trapping
wapping153514603__wapping
whapping19317113_whapping
wiretapping1951793wiretapping
wrapping16297623_wrapping
yapping153412613__yapping
zapping213211473__zapping

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.423422437.4
2DLD Change Limit1486411966.71622132.4
3Display Results1961960.0932107.5
 (SQL Overall)1786911967.23224708.4
 
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.