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

362 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
recanting12241482(None) 
decanting132510631decanting
recaning111416691recan_ing
recasting122414231recasting
canting104725902__canting
descanting1446922descanting
incanting1289902incanting
levanting1345522levanting
precasting15169832precasting
precenting151012152precenting
ranting84025412r__anting
reacting113317892re_acting
rebaiting12311642rebaiting
rebating112418342reba_ting
recalling122211902recalling
recapping1636452recapping
rechanging1746042rechanging
recharting1637212recharting
reciting113118072rec_iting
recoating121317462recoating
reconning121410792reconning
recounting1339192recounting
recrating121318792recrating
recutting1239482recutting
redacting13612302redacting
redating102620172reda_ting
regranting1238322regranting
rehanging1437562rehanging
relanding112110922relanding
relating92725442rela_ting
relenting102716772relenting
remanding132211142remanding
remanning12229032remanning
remating112322412rema_ting
reminting122315102reminting
renting84026852re__nting
repainting13128972repainting
repasting122312842repasting
repenting122316552repenting
replanting1338522replanting
rerenting102617662rerenting
resenting102619292resenting
retasting102513412retasting
retinting102215252retinting
scanting113914762_scanting
tenanting1036212tenanting
accenting1487823accenting
aerating92821003aera_ting
anting75827023___anting
beaning103820683be_an_ing
beating104326873be_a_ting
becalming1635283becalming
becapping1834243becapping
bechancing2044443bechancing
bepainting15144883bepainting
berating113220763bera_ting
breasting1239583bre_asting
caning94128623__can_ing
canning103620133__canning
cantina93417253__cantina
carting104228283__carting
casting104628343__casting
catting103922643__catting
cementing1438763cementing
chanting143413533_chanting
creating113921953cre_a_ting
cremating14312193crema_ting
deaning94020473de_an_ing
debating123213733deba_ting
decamping1734943decamping
decaying15239453deca_ying
decentring1446753decentring
decocting1538123decocting
defanging1535333defanging
defatting1436103defatting
delating103119603dela_ting
demanding14237923demanding
demasting1338453demasting
dementing13311043dementing
denting94422183de__nting
depainting14156153depainting
departing1349513departing
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desanding12207653desanding
discanting1449453discanting
eanling81416673_e_anling
easting84924303_e_asting
eating75134403_e_a_ting
elating83423083_ela_ting
emanating1239003_emanating
enacting11311363_enacting
enchanting1645943enchanting
erecting112415063erec__ting
exacting1838523_exacting
exalting1638033_exalting
feasting122011323fe_asting
feinting123410833fe_inting
forecasting1744473forecasting
gelating103015733gela_ting
granting103514523_granting
hanting114124483__hanting
hearting12513123he_arting
heating114024323he_a_ting
henting113719653he__nting
incenting12912063incenting
leaning83721203le_an_ing
legating102313113lega_ting
levantine1264793levantine
locating11311503loca_ting
meaning103918703me_an_ing
merchanting1944313merchanting
negating102012833nega_ting
panting104025423__panting
penancing1436343penancing
planting113515383_planting
preacting142412533pre_acting
precutting1546423precutting
predating13514653preda_ting
prepasting15168883prepasting
preplanting1645933preplanting
presenting131013023presenting
pretasting13239283pretasting
preventing161210263preventing
quanting1849233_quanting
racheting1537793racheting
racketing1647873racketing
rafting113815753r__afting
ranging94120263r__anging
ranking124320883r__anking
rating74938703r__a_ting
ratting83822363r__atting
reaccenting1665013reaccenting
reaching143317203re_aching
readapting1445153readapting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
reaming103924013re_a_ming
reanoint8413013re_anoint
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reaving113820533re_a_ving
rebinding13249483rebinding
rebooting12139023rebooting
rebutting1237523rebutting
recant83228683recant___
recanted112513513recant_ed
recanter101913153recant_er
recanters112310483recanters
recants93217093recant__s
recapturing1643763recapturing
recarpeting1674363recarpeting
recarrying1643653recarrying
recaution1148093recaution
recautions1247813recautions
receding122713763rec_eding
receipting1546753receipting
receiving1538993receiving
recementing1645223recementing
recessing12611013recessing
recharging1745293recharging
rechewing1836493rechewing
recking144319923rec__king
reckoning1637643reckoning
recladding1543973recladding
reclaiming1546583reclaiming
reclasping15105083reclasping
recleaning1336753reclean_ing
reclining121112283reclining
reclothing1644973reclothing
recoaling121312453recoaling
recocking18138373recocking
recoding122213853rec_oding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconfine1448013reconfine
reconsign1245243reconsign
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recouping1438363recouping
recreating131214583recreating
recruiting1347903recruiting
recurring1237953recurring
recurving1536773recurving
recusing112512883rec_using
recycling1734903recycling
redbaiting1446263redbaiting
redenying1437783redenying
redonning11127643redonning
redrafting1545963redrafting
reearning1039053reearning
reediting11310953reediting
reenacting1357353reenacting
reesting93118273re_esting
refacing142512813refa_cing
refalling132010423refalling
refecting152413353refecting
refencing15188853refencing
refinding14259943refinding
refining122416863refin_ing
refitting132811123refitting
reflating132514713reflating
refracting1638733refracting
refronting1437273refronting
refunding14258073refunding
refuting121911903re_futing
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regrafting1545993regrafting
regrating111316213regrating
rehabbing1733653rehabbing
rehandling1544453rehandling
rehashing1647113rehashing
reheating132314913reheating
rehinging1437453rehinging
reigning1039883reign_ing
reigniting1246373reigniting
reining84425323re_in_ing
reinking13311023re_inking
rejecting192211153rejecting
relacing112516043rela_cing
relapsing1236843relapsing
relaxing162612633rela_xing
relaying122515153rela_ying
relending112412023relending
reletting102713943reletting
relining93218743relin_ing
relinking1458253relinking
relisting102414353relisting
reloaning10710483reloan_ing
relocating13310873reloca_ting
relucting1239773relucting
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remapping1635023remapping
remarking1638893remarking
remeeting12311433remeeting
remelting12311703remelting
remending132311313remending
reminding132311543reminding
remitting122412623remitting
remounting1346673remounting
renailing102813333renailing
renaming11313693rena_ming
rending93924263re__nding
renesting102514703renesting
repacking1838283repacking
repairing12310013repairing
repaneling1345733repaneling
reparking1638923reparking
repassing12249423repassing
repaving142810743repa_ving
repaying142712393repa_ying
repeating122618983repeating
repining114116593repin_ing
repinning12258973repinning
replanning1345313replanning
replating122217403replating
reporting12513903reporting
repotting12511123repotting
reprinting131510583reprinting
reputing112412603re_puting
requiting1939883requiting
reracking1639313reracking
reraising10313773reraising
rerouting10311873rerouting
rerunning1036523rerunning
resailing103314253resailing
resaluting1137393resaluting
resawing122311433resa_wing
resaying122512453resa_ying
rescaling122212013resca_ling
rescinding1436723rescinding
reseating102421533reseating
resecting122816483resecting
resending112313363resending
resetting102816293resetting
resifting133512093resifting
resinating11313733resinating
resining92919553resin_ing
resisting103215313resisting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resonating11311263resonating
resorting10614613resorting
respiting121912863respiting
restarting11310663restarting
restating102319413restating
resting85031183re__sting
resulting10311083resulting
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retaining102114733retaining
retaking133114283reta_king
retaping113012553reta_ping
retarding111110653retarding
retaxing162311333reta_xing
retesting102614603retesting
retorting10613273retorting
retracting13311933retracting
retting83425883re__tting
retuning9311583retun_ing
reuniting10310693reuniting
revaluing1337303revaluing
revamping1734633revamping
revenging1438083revenging
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
revolting1339633revolting
revoting12312033re_voting
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
rewetting132710443rewetting
rewinding14238933rewinding
rewinning13257443rewinning
rewriting13310413rewriting
rezoning18310453rezon_ing
roasting93012703r_oasting
rocketing1666973rocketing
romancing1446043romancing
rotating92614553rota_ting
ruinating1039593ruinating
scanning113310773_scanning
scantling12107233_scantling
scarting113415263_scarting
scatting113311813_scatting
scenting113212813_scenting
seating84130683se_a_ting
seconding1337613seconding
secreting1279823secreting
sedating103014113seda_ting
slanting94115093_slanting
tenting84621153te__nting
treating92519613tre_a_ting
trepanning1344153trepanning
truanting1035603truanting
upcasting1434823upcasting
vacating14310353vaca_ting
venting114218093ve__nting
wanting114220173__wanting
weaning114117193we_an_ing
weanling12118643we_anling
webcasting1842483webcasting
yeaning113814633ye_an_ing
yeanling12107063ye_anling
yeasting12188923ye_asting

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.420425454.8
2DLD Change Limit1486413627.22020587.4
3Display Results3623620.1732092.5
 (SQL Overall)1786913627.81322871.0
 
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.