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

409 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
recanted11251351(None) 
decanted122310491decanted
recaned102817201recan_ed
recanter101913151recanter
canted94825782__canted
decanter112510792decanter
descanted1336672descanted
incanted11259542incanted
levanted1245322levanted
precented14310692precented
ranted74324702r__anted
reacted103015712re_acted
rebaited11410542rebaited
rebated103619702reba_ted
recalled11310802recalled
recane83022872recan_e_
recanes93222262recan_es
recant83228682recant__
recanters112310482recanters
recants93217092recant_s
recapped1535942recapped
recenter102715442recenter
rechanged1646852rechanged
recharted1557562recharted
recited104319102rec_ited
recoated113416782recoated
reconned113610652reconned
recounted1238712recounted
recrated112918602recrated
redacted12410242redacted
redated93120922reda_ted
regranted1137702regranted
rehanged1357832rehanged
relanded102410462relanded
related83327572rela_ted
relented92614942relented
remanded123011322remanded
remanned11319352remanned
remated103522472rema_ted
reminted113615082reminted
rented74426592re__nted
repainted1277862repainted
repasted112611532repasted
repented112614982repented
replanted1248062replanted
rerented92516162rerented
resented92716962resented
retasted92412112retasted
retinted94414362retinted
scanted104114392_scanted
tenanted937042tenanted
accented13107773accented
aerated85322373aera_ted
anted66328243___anted
beaned95621473be_an_ed
becalmed1534813becalmed
becapped1733933becapped
bechanced1945643bechanced
belated103520013bela_ted
bepainted1484343bepainted
berated104422133bera_ted
breasted1138823bre_asted
caned85838093__can_ed
canned95022063__canned
canoed94618963__canoed
canter85230113__canter
carted98631443__carted
catted95422473__catted
cemented1338373cemented
cerated103922473cera_ted
chanted134015953_chanted
created104323453cre_a_ted
cremated133412963crema_ted
crenated113013913crena_ted
deaned84620453de_an_ed
debated113916083deba_ted
decamped1634963decamped
decane93818873decan_e_
decanes103118913decan_es
decant93524223decant__
decanters12229223decanters
decants103514443decant_s
decayed14309333deca_yed
decenter112412163decenter
decentred13236233decentred
decocted1437683decocted
defanged1435433defanged
defatted1335673defatted
delated93722873dela_ted
demanded13348513demanded
demasted1238763demasted
demented12311273demented
dented84120513de__nted
depainted1375843depainted
departed1238823departed
deranged1137693deranged
derated93623503dera_ted
deratted1048403deratted
desalted1038313desalted
desanded11227453desanded
descanter1246443descanter
discanted1339333discanted
ecarte84313503_ecarte_
ecartes94212563_ecartes
elated74725823_ela_ted
emanated1139163_emanated
enacted10310643_enacted
enchanted1546553enchanted
erected103213993erec__ted
exacted1737303_exacted
exalted1537393_exalted
exapted1736073_exapted
feasted11310843fe_asted
feinted11379623fe_inted
forecasted1685103forecasted
gelated93615633gela_ted
granted94715103_granted
hanted104124313__hanted
hearted113314023he_arted
heated104525593he_a_ted
hented104218753he__nted
incented112412543incented
jeaned143813463je_an_ed
leaned73422543le_an_ed
legated92513983lega_ted
levanter1145303levanter
located103114183loca_ted
meated94222403me_a_ted
merchanted1844483merchanted
negated93413233nega_ted
panted95024823__panted
penanced1338163penanced
pennated11299543pennated
picante11310523picante_
planted103516123_planted
preacted132710943pre_acted
precancel1546203precancel
precancer1547093precancer
precited133013813prec_ited
predated12513273preda_ted
prepasted14137673prepasted
presented12311633presented
pretasted12147963pretasted
prevented1539003prevented
quanted1738963_quanted
racheted14149503racheted
racketed15169123racketed
rafted104714703r__afted
ranged84824313r__anged
ranked114620743r__anked
ranter63826823r__anter
rated65441383r__a_ted
ratted74923343r__atted
reaccented1544893reaccented
reached134619083re_ached
readapted1344803readapted
readded103310733re_added
readied93316623re_adied
realter73716313re_alter
reamed94326123re_a_med
reannex1434733re_annex
reaped94122453re_a_ped
reared75930013re_a_red
rearmed103912823re_armed
reaved104523923re_a_ved
rebate84424113reba_te_
rebater93517913reba_ter
rebates95123183reba_tes
rebooted11248463rebooted
rebutted11126783rebutted
recaller1039323recaller
recamier1237603recamier
recaning111416693recaning
recanting122414823recanting
recaptured1573593recaptured
recarpet12310603recarpet
recarpeted1543703recarpeted
recarried1244983recarried
recast83422773recast__
recasts93413533recast_s
receded112713043rec_eded
receipted1445333receipted
received1437983received
recemented1546163recemented
recent83630853recent__
recentest11410283recentest
recently1339423recently
recessed1139713recessed
rechange1458183rechange_
rechanges1568183rechanges
rechannel1444323rechannel
recharged1656333recharged
recharter1466893recharter
rechewed1735633rechewed
recite83625113rec_ite_
reciter94117263rec_iter
recites93524583rec_ites
recked134821803rec__ked
reckoned1546953reckoned
recladded1443673recladded
reclaimed1435543reclaimed
reclasped1444863reclasped
recleaned1236583reclean_ed
reclined113613603reclined
reclothed1544593reclothed
recoaled113111783recoaled
recocked17248473recocked
recoded113115033rec_oded
recoiled113613213recoiled
recoined113614423recoined
recombed1536713recombed
reconfer1337673reconfer
reconvey1655603reconvey
recooked15268243recooked
recopied1339843recopied
recorded122511063recorded
recorked15239853recorked
recounter1137943recounter
recouped13128663recouped
recrate92621663recrate_
recrates102420373recrates
recreated12412533recreated
recruited1236453recruited
recurred1137093recurred
recurved1436493recurved
recused104714423rec_used
recycled1634813recycled
redate74124683reda_te_
redates83423873reda_tes
redbaited1344713redbaited
redenied10511283redenied
redonned10297103redonned
redrafted1435143redrafted
reearned948883reearned
reedited10310083reedited
reenacted1236853reenacted
reenter73217793re_enter
reested82916233re_ested
refaced133713573refa_ced
refasten1136103refasten
refected142311663refected
refenced1438993refenced
refined114720003refin_ed
refitted12309413refitted
reflated123514293reflated
refracted1557393refracted
refronted1336053refronted
refunded1336953refunded
refuted114313803re_futed
regained102111243regained
regaled93615963rega_led
regarded11279803regarded
regauged1135143regauged
regrafted1435243regrafted
regrated102816333regrated
rehabbed1663713rehabbed
rehandled1444763rehandled
rehashed1536063rehashed
reheated122415003reheated
rehinged1336853rehinged
reigned949213reign_ed
reignited1145683reignited
reined74425523re_in_ed
reinked1239793re_inked
reinter73116843re_inter
rejected182710113rejected
relaced103517213rela_ced
reland75920433relan__d
relapsed1136523relapsed
relate64033633rela_te_
relater73723143rela_ter
relates73731433rela_tes
relaxed153312533rela_xed
relayed113212753rela_yed
relined85321933relin_ed
relinked1337003relinked
relisted9312623relisted
reloaned939723reloan_ed
relocated12710813reloca_ted
relucted1138653relucted
remailed112411403remailed
remained112412893remained
remand95618963reman__d
remapped1534913remapped
remarked15209243remarked
remaster10311473remaster
remate84428683rema_te_
remates93827113rema_tes
remelted11310153remelted
remended123010393remended
reminded123411523reminded
remitted113312073remitted
remounted1236283remounted
renailed92512803renailed
renamed103114523rena_med
rended84524103re__nded
renested92212953renested
rente54733783re__nte_
renter64527413re__nter
rentes65431193re__ntes
repacked17188743repacked
repaired1148953repaired
repand95316063repan__d
repanel939963repan_el
repaneled1245333repaneled
reparked15208923reparked
repartee10312753repartee
repassed11229273repassed
repaved133311133repa_ved
repeated113117443repeated
repenter102813863repenter
repined104918773repin_ed
repinned1157473repinned
replanned1235163replanned
replated112817523replated
reported11312703reported
repotted1139283repotted
reprinted1289043reprinted
reputed104613483re_puted
requited18169723requited
reracked15169123reracked
reraised9312353reraised
rerouted9311143rerouted
resailed93613063resailed
resaluted1046473resaluted
resawed113111183resa_wed
rescaled113311303resca_led
rescinded1335763rescinded
reseated93220263reseated
resected112514743resected
resifted12310153resifted
resinated10413283resinated
resined84522653resin_ed
resisted9312693resisted
resited85122423re_sited
reslated93517523reslated
resonated10510613resonated
resorted9313493resorted
respited11410813respited
restarted10410053restarted
restated93120183restated
rested74430783re__sted
resulted939713resulted
retacked15169273retacked
retagged1136063retagged
retailed94113963retailed
retained93016093retained
retaped103814283reta_ped
retarded102410753retarded
retaste72313133retaste_
retastes82212903retastes
retaxed153512233reta_xed
retested92212533retested
retinued95210823retinued
retorted9312333retorted
retracted12410953retracted
retted74826313re__tted
retuned86613973retun_ed
reunited939713reunited
revalued1237023revalued
revamped1634143revamped
revenged1337553revenged
revenued1237223revenued
reverted122714713reverted
revested122612243revested
revetted122210943revetted
revolted12319863revolted
revoted114314153re_voted
rewaked153811903rewa_ked
rewarded13229523rewarded
rewarmed14257433rewarmed
rewashed1546243rewashed
rewaxed18409343rewa_xed
rewetted12228353rewetted
rewinded13277673rewinded
rezoned173611163rezon_ed
roasted83912663r_oasted
rocketed15157793rocketed
romanced1337253romanced
rotated82715293rota_ted
ruinated939523ruinated
scanned104110893_scanned
scanter94215183_scanter
scarted104816123_scarted
scatted103512773_scatted
scented102811883_scented
seated75131063se_a_ted
secant84023293secant__
secantly1345983secantly
secants93413893secant_s
seconded1236353seconded
secreted1138633secreted
sedated93714353seda_ted
slanted83514743_slanted
teated74924023te_a_ted
tented74221003te__nted
treated83618703tre_a_ted
trepanned1243913trepanned
truanted935373truanted
uncanned11289963uncanned
uncarted11312053uncarted
unwanted12249603unwanted
vacated1349353vaca_ted
vented104617923ve__nted
wanted104319723__wanted
weaned103816153we_an_ed
webcasted1741973webcasted
yeaned103813903ye_an_ed
yeasted1138503ye_asted

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.436409841.7
2DLD Change Limit1461624097.78318779.6
3Display Results4094090.1702405.9
 (SQL Overall)1786914098.38921300.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.