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

378 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
recoating12131746(None) 
recoaling121312451recoaling
recrating121318791recrating
coating103525312__coating
decocting1538122decocting
decorating14312072decorating
rebating112418342re_bating
rebooting12139022rebooting
recaning111416692rec_aning
recanting122414822recanting
recasting122414232recasting
recharting1637212recharting
reciting113118072rec_iting
recocking18138372recocking
recoding122213852reco_ding
recoiling121412412recoiling
recoining121313802recoining
recombing1637322recombing
reconning121410792reconning
recooking16148542recooking
recopying1737112recopying
recording131311622recording
recorking16149642recorking
recounting1339192recounting
recouping1438362recouping
recreating131214582recreating
recutting1239482recutting
redating102620172re_dating
reflating132514712reflating
refloating14198322refloating
regrating111316212regrating
reheating132314912reheating
relating92725442re_lating
reloading1189882reloading
reloaning10710482reloaning
relocating13310872relocating
remating112322412re_mating
renovating1447422renovating
repeating122618982repeating
replating122217402replating
reporting12513902reporting
repotting12511122repotting
rerouting10311872rerouting
reseating102421532reseating
reslating102516992reslating
resoaking1439372resoaking
resonating11311262resonating
resorting10614612resorting
restating102319412restating
retorting10613272retorting
revolting1339632revolting
revoting12312032revo_ting
uncoating12611922uncoating
accosting1446733accosting
aerating92821003ae_rating
beating104326873be__ating
becloaking1944883becloaking
becoming1538163beco_ming
bemoaning1435953bemoaning
berating113220763be_rating
besotting12256873besotting
bloating113512813_bloating
boating103721303__boating
brecciating1844223brecciating
coacting133412703__coacting
coaling103722823__coaling
coaming123818323__coaming
coapting133511613__coapting
coasting113615513__coasting
coatings113811843__coatings
coaxing173511703__coaxing
costing104323023__costing
coting94629253__co_ting
crating103725203__crating
creating113921953cre__ating
cremating14312193cre_mating
debating123213733de_bating
decanting132510633decanting
decaying15239453dec_aying
deceasing1338403deceasing
decimating1648753decimating
declaring1339573declaring
declawing1636213declawing
decoding132410053deco_ding
decollating1545963decollating
decoying15208763deco_ying
defeating142311973defeating
deflating142610713deflating
defoaming1645653defoaming
dehorting1447213dehorting
delating103119603de_lating
demoting12311423demo_ting
denoting10311753deno_ting
deporting1369593deporting
derating103222283de_rating
derogating1348633derogating
desolating1239463desolating
detonating1248823detonating
deviating14311083deviating
devoting1338823devo_ting
dictating1338883dictating
doating93816863__doating
eating75134403_e__ating
elating83423083_e_lating
emoting10313563_emo_ting
equating18310113_equating
erecting112415063erec__ting
eructating1345693eructating
escorting1237713escorting
escoting1158713esco_ting
estating92614993_estating
execrating2047883execrating
fellating1339243fellating
floating123111883_floating
gelating103015733ge_lating
gemmating1576443gemmating
gestating11229983gestating
gloating102611463_gloating
heating114024323he__ating
iceboating1543353iceboating
lactating1239183lactating
legating102313113le_gating
locating11311503loc_ating
mediating13311203mediating
moating104218153__moating
negating102012833ne_gating
nictating1237573nictating
peculating1549153peculating
percolating1657323percolating
perorating13313133perorating
picoting1338883pico_ting
precasting15169833precasting
precenting151012153precenting
precoding15109733preco_ding
precooking1945043precooking
precooling1545963precooling
precutting1546423precutting
predating13514653pre_dating
preheating16310723preheating
preloading1446583preloading
prelocating1647413prelocating
presoaking1736253presoaking
presorting1339983presorting
racheting1537793racheting
racketing1647873racketing
radiating111112123radiating
ragouting1134893ragouting
rating74938703r___ating
reacting113317893re_acting
readapting1445153readapting
reading93327213re__ading
readopting1465513readopting
reaming103924013re__aming
reaping103621213re__aping
rearing83128783re__aring
reaving113820533re__aving
reawaking17216073reawaking
rebaiting12311643rebaiting
reboarding1445673reboarding
rebodying1635003rebodying
reboiling12149823reboiling
rebooking16146393rebooking
reboring11312783rebo_ring
rebottling1343733rebottling
rebutting1237523rebutting
recalling122211903recalling
recapping1636453recapping
receding122713763rec_eding
receipting1546753receipting
receiving1538993receiving
recessing12611013recessing
rechanging1746043rechanging
recharging1745293recharging
rechewing1836493rechewing
rechoosing1645373rechoosing
recking144319923rec__king
reckoning1637643reckoning
recladding1543973recladding
reclaiming1546583reclaiming
reclasping15105083reclasping
recleaning1336753recleaning
reclining121112283reclining
reclothing1644973reclothing
recoat84024273recoat___
recoated113416783recoat_ed
recoats92616643recoat__s
recoin84320293reco__in_
recoins94019243reco__ins
recoloring1367583recoloring
recombine1546103recombine
recomputing1844343recomputing
reconfine1448013reconfine
reconsign1245243reconsign
recontacting1745063recontacting
recordings14144653recordings
recoupling1545043recoupling
recovering1647373recovering
recrossing1386973recrossing
recrowning1645213recrowning
recruiting1347903recruiting
recurring1237953recurring
recurving1536773recurving
recusing112512883rec_using
recycling1734903recycling
redacting13612303redacting
redbaiting1446263redbaiting
redecorating16115053redecorating
redialing11311843redialing
redictating1546803redictating
redocking17126783redocking
redoing93516733redo__ing
redonning11127643redonning
redrafting1545963redrafting
redrawing1437213redrawing
reediting11310953reediting
reenacting1357353reenacting
reesting93118273re_esting
refacing142512813re_facing
refecting152413353refecting
refitting132811123refitting
refolding1437453refolding
reforging1437663reforging
reforming1538563reforming
refracting1638733refracting
reframing1538623reframing
refronting1437273refronting
refuting121911903re_futing
regaling10315363re_galing
regearing112211413regearing
regelating1239953regelating
reglazing2046553reglazing
regorging1236823regorging
regrading121210203regrading
regrafting1545993regrafting
regranting1238323regranting
regulating12310063regulating
rehearing132211763rehearing
rehousing1337253rehousing
reimaging1336503reimaging
rejecting192211153rejecting
rejoicing19136943rejoicing
rejoining17149223rejoining
reknotting1564233reknotting
relacing112516043re_lacing
relaxing162612633re_laxing
relaying122515153re_laying
releasing10411013releasing
relegating1239483relegating
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
relocking16137683relocking
relooking14167143relooking
reluctating1445763reluctating
relucting1239773relucting
remaking152613303re_making
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remitting122412623remitting
remolding1338163remolding
remounting1346673remounting
removing1439083remo_ving
renaming11313693re_naming
renesting102514703renesting
renowning1336083renowning
renting84026853re__nting
reoiling93217213re_oiling
repasting122312843repasting
repaving142810743re_paving
repaying142712393re_paying
repealing122513543repealing
repenting122316553repenting
replacing142210163replacing
replanting1338523replanting
replaying15259603replaying
replotting1357043replotting
repolling122110203repolling
reposing111213803repo_sing
repositing13310493repositing
repouring12310073repouring
reprobating1647103reprobating
reputing112412603re_puting
requiting1939883requiting
rereading111212713rereading
rerenting102617663rerenting
rerolling102210373rerolling
reroofing1336863reroofing
resawing122311433re_sawing
resaying122512453re_saying
rescaling122212013rescaling
rescoring12310603resco_ring
resealing102115673resealing
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
reshaping1557743reshaping
reshaving1657273reshaving
reshooting1436223reshooting
resifting133512093resifting
resinating11313733resinating
resisting103215313resisting
resiting93521123re_siting
resitting103414873resitting
resodding1237203resodding
resoling92916303reso_ling
resolving1337743resolving
resorbing1269353resorbing
resowing123111523reso_wing
respacing1438893respacing
respading1338803respading
respiting121912863respiting
respotting1347113respotting
restaging112410853restaging
restarting11310663restarting
resting85031183re__sting
resulting10311083resulting
retaking133114283re_taking
retaping113012553re_taping
retasting102513413retasting
retaxing162311333re_taxing
reteaming122110443reteaming
retearing102214253retearing
retesting102614603retesting
retinting102215253retinting
retooling1039093retooling
retotaling1186883retotaling
retracing12313293retracing
retracting13311933retracting
retreating111414773retreating
retroacting1447283retroacting
retting83425883re__tting
reuniting10310693reuniting
revealing132611883revealing
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
reviolating1556253reviolating
revoicing15117713revoicing
revoking1637803revo_king
revolving1635843revolving
rewaking162310983re_waking
rewaxing19248563re_waxing
rewearing132310703rewearing
reweaving16227073reweaving
rewetting132710443rewetting
rewording14158543rewording
reworking17136873reworking
rewriting13310413rewriting
rezoning18310453rezo_ning
rioting82716393r_io_ting
riposting1236063riposting
roaming103215793r__oaming
roaring82916003r__oaring
roasting93012703r__oasting
rocketing1666973rocketing
roosting93411463r_oosting
rooting83522433r__ooting
rotating92614553r_otating
rotting82919683r__otting
routing83821093r__outing
ruinating1039593ruinating
scooting113012643_scooting
scouting112612753_scouting
seating84130683se__ating
seconding1337613seconding
secreting1279823secreting
sedating103014113se_dating
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
speciating1548123speciating
spectating1546623spectating
throating1398403throating
treating92519613tre__ating
uncoatings1384793uncoatings
uncrating12813183uncrating
vacating14310353vac_ating

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.440406115.9
2DLD Change Limit1486413787.48319863.8
3Display Results3783780.1732185.0
 (SQL Overall)1786913788.09622071.5
 
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.