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

389 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
recrating12131879(None) 
recoating121317461recoating
recreating131214581recreating
regrating111316211regrating
aerating92821002ae_rating
berating113220762be_rating
crating103725202__crating
decorating14312072decorating
derating103222282de_rating
execrating2047882execrating
rebating112418342re_bating
recaning111416692rec_aning
recanting122414822recanting
recasting122414232recasting
recharting1637212recharting
reciting113118072rec_iting
recoaling121312452recoaling
recruiting1347902recruiting
recutting1239482recutting
redating102620172re_dating
redrafting1545962redrafting
redrawing1437212redrawing
reflating132514712reflating
refracting1638732refracting
reframing1538622reframing
regrading121210202regrading
regrafting1545992regrafting
regranting1238322regranting
reheating132314912reheating
relating92725442re_lating
remating112322412re_mating
repeating122618982repeating
replating122217402replating
reseating102421532reseating
reslating102516992reslating
restating102319412restating
retracing12313292retracing
retracting13311932retracting
retreating111414772retreating
rewriting13310412rewriting
secreting1279822secreting
serrating10513202serrating
uncrating12813182uncrating
accreting1446333accreting
acerbating1546283acerbating
beating104326873be__ating
becrawling1843613becrawling
becriming1646363becriming
becrusting1544603becrusting
bedraping1535383bedraping
beraking153612973be_raking
betraying1537713betraying
bewraying1834873bewraying
borating113414503_borating
brecciating1844223brecciating
carting104228283__carting
ceratin93020163ce_ratin_
ceratins102818733ce_ratins
cerebrating1646663cerebrating
coating103525313__coating
cocreating15310293cocreating
crafting143710173__crafting
craning103620303__craning
craping124018713__craping
craving134015733__craving
crazing193914583__crazing
creating113921953__creating
cremating14312193cre_mating
curating11314293_curating
deaerating12311563deaerating
debating123213733de_bating
decanting132510633decanting
decaying15239453dec_aying
deceasing1338403deceasing
decimating1648753decimating
declaring1339573declaring
declawing1636213declawing
decocting1538123decocting
decreasing1446513decreasing
decreeing1335523decreeing
decrying15237413decr_ying
decrypting1943213decrypting
defeating142311973defeating
deflating142610713deflating
defraying1735853defraying
degrading13137373degrading
delating103119603de_lating
departing1349513departing
depraving1635973depraving
depurating1438643depurating
deratting1139513de_ratting
desecrating1548093desecrating
detracting1438713detracting
deviating14311083deviating
dictating1338883dictating
disrating11714553disrating
eating75134403_e__ating
elating83423083_e_lating
enraging1049573_enraging
equating18310113_equating
erasing8317963_e_rasing
erecting112415063erec__ting
eructating1345693eructating
estating92614993_estating
excreting1946433excreting
federating1548853federating
fellating1339243fellating
ferreting13127693ferreting
furcating1537783furcating
gelating103015733ge_lating
gemmating1576443gemmating
generating12310383generating
gestating11229983gestating
grating93923183__grating
gyrating1337453_gyrating
hearting12513123hear_ting
heating114024323he__ating
hydrating1746323hydrating
iterating10314253iterating
keratin113314153ke_ratin_
keratins122313483ke_ratins
lacerating1349443lacerating
lactating1239183lactating
legating102313113le_gating
librating1239053librating
locating11311503loc_ating
macerating1549533macerating
mediating13311203mediating
mercurating1645953mercurating
meriting11314683me_riting
migrating13910533migrating
misrating121014853misrating
narrating10310353narrating
necrosing1247693necrosing
negating102012833ne_gating
nictating1237573nictating
nitrating10312673nitrating
obsecrating1644133obsecrating
operating12313723operating
orating83520323__orating
outrating10916403outrating
overrating14814203overrating
peculating1549153peculating
perorating13313133perorating
pirating11314513_pirating
prating103424453__prating
precasting15169833precasting
precenting151012153precenting
precreasing1645703precreasing
precutting1546423precutting
predating13514653pre_dating
preheating16310723preheating
pretreating1448893pretreating
prewriting1647243prewriting
procreating1647693procreating
prorating12314283prorating
racheting1537793racheting
racketing1647873racketing
radiating111112123radiating
rating74938703___rating
reacting113317893re_acting
readapting1445153readapting
reading93327213re__ading
reaming103924013re__aming
reaping103621213re__aping
rearguing1135603rearguing
rearing83128783re__aring
rearming111413613rear_ming
reaving113820533re__aving
reawaking17216073reawaking
rebaiting12311643rebaiting
rebooting12139023rebooting
rebutting1237523rebutting
recalling122211903recalling
recapping1636453recapping
recarpeting1674363recarpeting
recarrying1643653recarrying
receding122713763rec_eding
receipting1546753receipting
receiving1538993receiving
recessing12611013recessing
rechanging1746043rechanging
recharging1745293recharging
rechewing1836493rechewing
recircling1543573recircling
recking144319923rec__king
reckoning1637643reckoning
recladding1543973recladding
reclaiming1546583reclaiming
reclasping15105083reclasping
recleaning1336753recleaning
reclining121112283reclining
reclothing1644973reclothing
recocking18138373recocking
recoding122213853rec_oding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recounting1339193recounting
recouping1438363recouping
recrate92621663recrat__e
recrated112918603recrat_ed
recrates102420373recrat_es
recreation12413613recreation
recreations13412253recreations
recreative1549023recreative
recrossing1386973recrossing
recrowning1645213recrowning
recuperating1744993recuperating
recurring1237953recurring
recurving1536773recurving
recusing112512883rec_using
recycling1734903recycling
redacting13612303redacting
redbaiting1446263redbaiting
redecorating16115053redecorating
redialing11311843redialing
redictating1546803redictating
redreaming1446443redreaming
redriving1437603redriving
redrying13209023redr_ying
reearning1039053reearning
reediting11310953reediting
reenacting1357353reenacting
reerecting1339973reerecting
reesting93118273re_esting
refacing142512813re_facing
refecting152413353refecting
refitting132811123refitting
refloating14198323refloating
refrain10310043refra_in_
refraining1437263refraining
refrains1139593refra_ins
refronting1437273refronting
refrying15278903refr_ying
refuting121911903re_futing
regaling10315363re_galing
regarding12149153regarding
regearing112211413regearing
regelating1239953regelating
reglazing2046553reglazing
regreeting1237343regreeting
regretting1237783regretting
regrowing1436673regrowing
regulating12310063regulating
rehearing132211763rehearing
rehydrating1944033rehydrating
reimaging1336503reimaging
reiterating12410493reiterating
rejecting192211153rejecting
relacing112516043re_lacing
relaxing162612633re_laxing
relaying122515153re_laying
releasing10411013releasing
relegating1239483relegating
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
reloading1189883reloading
reloaning10710483reloaning
relocating13310873relocating
reluctating1445763reluctating
relucting1239773relucting
remaking152613303re_making
remarking1638893remarking
remeeting12311433remeeting
remelting12311703remelting
remigrating1547593remigrating
reminting122315103reminting
remitting122412623remitting
renaming11313693re_naming
renesting102514703renesting
renovating1447423renovating
renting84026853re__nting
reoperating1449023reoperating
reparking1638923reparking
repasting122312843repasting
repaving142810743re_paving
repaying142712393re_paying
repealing122513543repealing
repenting122316553repenting
rephrasing1645643rephrasing
replacing142210163replacing
replanting1338523replanting
replaying15259603replaying
reporting12513903reporting
repotting12511123repotting
repricing14310473repricing
reprinting131510583reprinting
reprising12312553reprising
reprobating1647103reprobating
reprobing1438073reprobing
reproving1538413reproving
reputing112412603re_puting
requiting1939883requiting
reracking1639313re_racking
reraising10313773re_raising
rereading111212713rereading
rerenting102617663rerenting
rerising93017783re_rising
rerouting10311873rerouting
resawing122311433re_sawing
resaying122512453re_saying
rescaling122212013rescaling
resealing102115673resealing
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
reshaping1557743reshaping
reshaving1657273reshaving
resifting133512093resifting
resinating11313733resinating
resisting103215313resisting
resiting93521123re_siting
resitting103414873resitting
resoaking1439373resoaking
resonating11311263resonating
resorting10614613resorting
respacing1438893respacing
respading1338803respading
respiting121912863respiting
respraying1636093respraying
restaging112410853restaging
restarting11310663restarting
resting85031183re__sting
resulting10311083resulting
retaking133114283re_taking
retaping113012553re_taping
retarding111110653retarding
retasting102513413retasting
retaxing162311333re_taxing
reteaming122110443reteaming
retearing102214253retearing
retesting102614603retesting
retinting102215253retinting
retorting10613273retorting
retracking1738163retracking
retrain7615423retra_in_
retraining11310243retraining
retrains8314533retra_ins
retreading12128483retreading
retroacting1447283retroacting
retrying122410453retr_ying
retting83425883re__tting
reuniting10310693reuniting
revealing132611883revealing
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
revibrating1745573revibrating
revolting1339633revolting
revoting12312033re_voting
rewaking162310983re_waking
rewarding14148833rewarding
rewarming15147383rewarming
rewaxing19248563re_waxing
rewearing132310703rewearing
reweaving16227073reweaving
rewetting132710443rewetting
rewrapping1843343rewrapping
rocketing1666973rocketing
rotating92614553r_otating
ruinating1039593ruinating
scarting113415263_scarting
scraping133310863_scraping
seating84130683se__ating
secretin10108343secretin_
secretins11108463secretins
sedating103014113se_dating
sensating1039253sensating
separating1348643separating
seriating10916403seriating
speciating1548123speciating
spectating1546623spectating
terracing1237703terracing
titrating10310113titrating
treating92519613tre__ating
ulcerating1346983ulcerating
uncoating12611923uncoating
uncreating13310473uncreating
uprating11311113_uprating
vacating14310353vac_ating
venerating14410053venerating
vibrating1537473vibrating

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 Filter1786911486410.423422437.4
2DLD Change Limit1486413897.45319943.8
3Display Results3893890.1732248.6
 (SQL Overall)1786913898.04922200.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.