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

299 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
recanter10191315(None) 
decanter112510791decanter
recanted112513511recanted
recanters112310481recanters
recenter102715441recenter
canter85230112__canter
decanted122310492decanted
decanters12229222decanters
decenter112412162decenter
descanter1246442descanter
levanter1145302levanter
precancer1547092precancer
ranter63826822r__anter
realter73716312re_alter
rebater93517912reba_ter
recaller1039322recaller
recamier1237602recamier
recane83022872recan_e_
recaned102817202recan_ed
recanes93222262recan_es
recant83228682recant__
recants93217092recant_s
recharter1466892recharter
reciter94117262rec_iter
reconfer1337672reconfer
recounter1137942recounter
reenter73217792re_enter
reinter73116842re_inter
relater73723142rela_ter
remaster10311472remaster
renter64527412re__nter
repenter102813862repenter
scanter94215182_scanter
banter84825333__banter
beater84729393be_a_ter
betatter1035453betatter
cancer104220923__cancer
caner75334773__can_er
canker124422523__canker
canner84625983__canner
canoer85121073__canoer
canted94825783__canted
canters94827733__canters
cantor85621523__cantor
carter84932273__carter
caster85232573__caster
cater74840723__ca_ter
cementer1239193cementer
center84421413__center
chanter123919733_chanter
debater104114693deba_ter
decaliter1247983decaliter
decameter14137363decameter
decane93818873decan_e_
decanes103118913decan_es
decant93524223decant__
decants103514443decant_s
decayer13339353deca_yer
decenters122410373decenters
decentre11248553decentre
demander12238723demander
deranger1037353deranger
desalter938363desalter
descanted1336673descanted
descanters1345013descanters
dewater112912423dewa_ter
easter65027983_e_aster
eater54639843_e_a_ter
ecarte84313503_ecarte_
ecartes94212563_ecartes
elater64724203_ela_ter
enchanter1446193enchanter
enter54726383_e__nter
erecter93113393erec__ter
exacter1637403_exacter
exalter1437563_exalter
feaster10812983fe_aster
feater95224053fe_a_ter
forecaster1586003forecaster
granter84117133_granter
greater84416493gre_a_ter
heater94828303he_a_ter
incanted11259543incanted
incenter102212093incenter
leaner64022193le_an_er
levanted1245323levanted
levanters1254993levanters
locater93113603loca_ter
meander1049973me_ander
meaner84617843me_an_er
neater64424313ne_a_ter
negater83711963nega_ter
pearter9412743pe_arter
picante11310523picante_
planter94017803_planter
prealter1048863pre_alter
precancel1546203precancel
precancers1645253precancers
precented14310693precented
precentor1348733precentor
presenter11311643presenter
preventer1438593preventer
raconteur1141993raconteur
rafter94517583r__after
ranger73925523r__anger
ranker105021903r__anker
ranted74324703r__anted
ranters73323643r__anters
raster64731443r__aster
rater54943283r__a_ter
ratter64326313r__atter
reacher123718293re_acher
reacted103015713re_acted
reactor93011653re_actor
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realters83614043re_alters
realtor73611353re_altor
reamer84325213re_a_mer
reannex1434733re_annex
reaper84223143re_a_per
rearer64928913re_a_rer
reaver94524733re_a_ver
rebaited11410543rebaited
rebate84424113reba_te_
rebated103619703reba_ted
rebaters103413943reba_ters
rebates95123183reba_tes
rebutter10106273rebutter
recalled11310803recalled
recallers1137103recallers
recamiers1345513recamiers
recaning111416693recaning
recanting122414823recanting
recapped1535943recapped
recapture1384713recapture
recarpet12310603recarpet
recast83422773recast__
recasts93413533recast_s
receiver1337413receiver
recensor1045543recensor
recent83630853recent__
recentest11410283recentest
recently1339423recently
receptor1256693receptor
rechange1458183rechange_
rechanged1646853rechanged
rechanges1568183rechanges
rechannel1444323rechannel
recharger1565483recharger
recharted1557563recharted
recharters1555423recharters
recite83625113rec_ite_
recited104319103rec_ited
reciters102613113rec_iters
recites93524583rec_ites
reckoner1446063reckoner
reclaimer1344463reclaimer
recliner103211913recliner
recoated113416783recoated
recoiler103210493recoiler
reconfers1437213reconfers
reconned113610653reconned
reconquer2084073reconquer
recontour1143713recontour
reconvert1449473reconvert
reconvey1655603reconvey
recorder11249633recorder
recounted1238713recounted
recounters1246213recounters
recover124312623rec_over
recrate92621663recrate_
recrated112918603recrated
recrates102420373recrates
recruiter1144873recruiter
rector84019753rec__tor
recycler1543683recycler
redacted12410243redacted
redactor1147023redactor
redate74124683reda_te_
redated93120923reda_ted
redates83423873reda_tes
redbaiter1244153redbaiter
reenters82915303re_enters
refasten1136103refasten
refilter1137153refilter
refiner105316913refin_er
refunder1236503refunder
refuter104312193re_futer
regainer9249353regainer
regaler83814623rega_ler
regather1236733regather
register939553register
regranted1137703regranted
rehabber1563153rehabber
rehammer1544653rehammer
rehanged1357833rehanged
reheater113413033reheater
reinters82614773re_inters
rejecter17258943rejecter
relanded102410463relanded
relapser1035273relapser
relate64033633rela_te_
related83327573rela_ted
relaters83218153rela_ters
relates73731433rela_tes
relator74016363rela_tor
relaunder1053703relaunder
relaxer143410223rela_xer
relented92614943relented
reletter81311023reletter
remainder1244683remainder
remaker133813173rema_ker
remanded123011323remanded
remanned11319353remanned
remarker14178493remarker
remasters11310583remasters
remate84428683rema_te_
remated103522473rema_ted
remates93827113rema_tes
reminder113110513reminder
reminted113615083reminted
remitter102810323remitter
remoter94815973re_moter
rencontre1144163rencontre
rencounter1244293rencounter
render74024143re__nder
rente54733783re__nte_
rented74426593re__nted
renters74224813re__nters
rentes65431193re__ntes
rentier73618223re__ntier
repainted1277863repainted
repairer1036783repairer
repanel939963repan_el
repaper11310023repa_per
repartee10312753repartee
repasted112611533repasted
repattern1143663repattern
repeater102615443repeater
repented112614983repented
repenters112511553repenters
repiner94816903repin_er
replanted1248063replanted
replaster1136583replaster
reporter10411423reporter
reprinter1197353reprinter
requiter17168643requiter
rerented92516163rerented
rescinder1245293rescinder
resented92716963resented
resetter81511833resetter
resister8311653resister
resorter8312183resorter
rester63832433re__ster
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retarder9229433retarder
retaste72313133retaste_
retasted92412113retasted
retastes82212903retastes
retinted94414363retinted
retorter8410733retorter
reuniter838323reuniter
reutter71010093re_utter
revamper1533533revamper
revenger1237303revenger
revenuer1136893revenuer
reverter114812873reverter
revolter11279363revolter
rewarder12208233rewarder
rewinder12317663rewinder
rewriter1137923rewriter
roaster74116663r_oaster
rocketer14158333rocketer
romancer1247293romancer
scanner94411813_scanner
scanted104114393_scanted
scantier10309983_scantier
scatter93815173_scatter
seater64534163se_a_ter
secant84023293secant__
secantly1345983secantly
secants93413893secant_s
secateur1042923seca_teur
seconder1137183seconder
secreter1038513secreter
sedater83713633seda_ter
tenanted937043tenanted
tenter64623933te__nter
treater74219833tre_a_ter
trepanner1143523trepanner
trochanter1544413trochanter
venter94218723ve__nter
wanter94423053__wanter
weaner93816773we_an_er
webcaster1642383webcaster

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.406440125.6
2DLD Change Limit1461622997.51619446.8
3Display Results2992990.1102718.2
 (SQL Overall)1786912998.03222247.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.