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

293 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
restoring1031461(None) 
prestoring13310301prestoring
rescoring12310601rescoring
restoking1438191restoking
restring91518781rest_ring
bestowing1535802bestowing
festering132413172festering
gesturing1136652gesturing
hectoring1538302hectoring
mentoring1239542mentoring
pastoring12310852pastoring
pestering122315662pestering
prescoring1547432prescoring
reboring11312782re_boring
reshoeing1336592reshoeing
reshowing1646632reshowing
resoling92916302res_oling
resorbing1269352res_orbing
resorting10614612res_orting
resowing123111522res_owing
respiring12159902respiring
respring111614062res_pring
restaging112410852restaging
restarting11310662restarting
restating102319412restating
resting85031182rest__ing
restocking1745702restocking
restrings10159292rest_rings
restrung9176442rest_rung
restyling1337922restyling
retiring92717412re_tiring
retorting10613272re_torting
sectoring1239582sectoring
storing83921122__storing
vectoring1537412vectoring
vesturing1337202vesturing
westering132112642westering
ancestoring1454103ancestoring
bescouring1584643bescouring
besmoking18114613besmoking
besnowing1544123besnowing
besotting12256873besotting
besting104923923best__ing
bestirring1343993bestirring
bestrowing1644373bestrowing
bettering122212763bettering
censoring1238783censoring
centering122915143centering
centring112112953cent_ring
cresting114017043crest__ing
deploring1337853deploring
desiring10312143des_iring
desorbing1346363des_orbing
destining11311433destining
destroying1564903destroying
detouring1136973de_touring
detoxing1736313de_toxing
distorting1239593distorting
doctoring1346183doctoring
encoring11312173_encoring
entering91920053_entering
escorting1237713_escorting
escoting1158713_escoting
estating92614993_estating
estopping1434793_estopping
estrin6315923_est_rin_
estrins7315853_est_rins
extorting1746763_extorting
factoring1537543factoring
featuring1337323featuring
festooning1444493festooning
fettering132310513fettering
fostering132411263fostering
frescoing1544683fresco_ing
gestating11229983gestating
gettering112310033gettering
jesting154317713jest__ing
lecturing1237303lecturing
leistering1147983leistering
lesioning1046443lesioning
lessoning1044773lessoning
lettering102112073lettering
lustering102711203lustering
lustring9269723lust_ring
mastering122315313mastering
metering112915633me_tering
metring103215293me_t_ring
motoring11410953_motoring
mustering122212333mustering
nesting84320443nest__ing
nestling958893nest_ling
neutering1038963neutering
oestrin7312243oest_rin_
oestrins8312673oest_rins
oystering1337563oystering
pasturing1238433pasturing
peltering122011673peltering
pestling111010253pest_ling
petering112516813pe_tering
pistoling1268493pistoling
posturing1238993posturing
preshowing1944473preshowing
presorting1339983pres_orting
pressuring1346513pressuring
proctoring1546673proctoring
rapturing1245363rapturing
razoring1836443r_azoring
readorning1245723readorning
realtering1139473realtering
rearing83128783re__aring
reasoning10310203reasoning
reassorting1245023reassorting
reassuring1155943reassuring
reavowing1634863reavowing
rebooking16146393rebooking
rebooting12139023rebooting
reckoning1637643reckoning
recoding122213853re_coding
recoloring1367583recoloring
recooking16148543recooking
recording131311623re_cording
recorking16149643re_corking
rectorial11119893rectorial
rectories11314663rectories
recurring1237953recurring
redoing93516733re_do_ing
reentering1149993reentering
reesting93118273reest__ing
reevoking1734223reevoking
referring1338033referring
refiring123513923re_firing
reflowing1636523reflowing
reforging1437663re_forging
reforming1538563re_forming
regearing112211413regearing
registering1346393registering
reglowing1436173reglowing
regorging1236823re_gorging
regrowing1436673regrowing
rehearing132211763rehearing
rehiring122911883re_hiring
relooking14167143relooking
remastering1446843remastering
removing1439083re_moving
renaturing11176813renaturing
rendering112213183rendering
renting84026853rent__ing
repairing12310013repairing
replowing1537413replowing
reporting12513903re_porting
reposing111213803re_posing
repotting12511123repotting
repouring12310073repouring
reprobing1438073reprobing
reproving1538413reproving
requiring1937043requiring
reroofing1336863reroofing
resailing103314253resailing
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
rescuing1139623res_cuing
resealing102115673resealing
reseating102421533reseating
resecting122816483resecting
resecuring1345123resecuring
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
resenting102619293resenting
reserving131110643reserving
resetting102816293resetting
resettling1135893resettling
resewing122712263res_ewing
reshaping1557743reshaping
reshaving1657273reshaving
reshining13310743reshining
reshooting1436223reshooting
reshowering1843163reshowering
residing103015483res_iding
resifting133512093resifting
resigning1139463resigning
resiling93520173res_iling
resining92919553res_ining
resisting103215313resisting
resiting93521123res_iting
resitting103414873resitting
resizing182714163res_izing
reslating102516993reslating
resoaking1439373resoaking
resodding1237203resodding
resolving1337743resolving
resorcin1046823res_orcin_
resorcins1146983res_orcins
respacing1438893respacing
respading1338803respading
respiting121912863respiting
responding1437403responding
respooling1355743respooling
respotting1347113respotting
resprang11175843res_prang
resprings12156253res_prings
resprung11164103res_prung
restabling1337653restabling
restacking1737183restacking
restaffing1744193restaffing
restamping1565213restamping
restoral8810983restor_al
restorals978073restorals
restore75822983restor__e
restored96417193restor_ed
restorer84813723restor_er
restorers95110113restorers
restores85222993restor_es
restrain8311703restrain_
restrains9311623restrains
restraint9412753restraint
restrict10313633rest_rict
restrike1239673rest_rike
restriking1548043restriking
restrive11310923rest_rive
restriving1448133restriving
restudying1543423restudying
restuffing1743163restuffing
resulting10311083resulting
resuming11310083res_uming
resurging1138613resurging
retaking133114283re_taking
retaping113012553re_taping
retarding111110653re_tarding
retaxing162311333re_taxing
retching143412173re_tching
retearing102214253retearing
retieing92913713re_tieing
retiling93319483re_tiling
retiming113014193re_timing
retooling1039093retooling
retorn610923433re_tor_n_
retrying122410453re_trying
retting83425883re_t_ting
retuning9311583re_tuning
returning1038133re_turning
retying113213833re_t_ying
retyping14255613re_typing
reuttering1137573reuttering
revering122918073re_vering
revoking1637803re_voking
revoting12312033re_voting
rewearing132310703rewearing
rewiring122911223re_wiring
rewording14158543re_wording
reworking17136873re_working
rezeroing1935933rezeroing
rezoning18310453re_zoning
roistering1148593roistering
roystering1445413roystering
rumoring1136983r_umoring
rupturing1244353rupturing
rusting83821263rust__ing
rustling9249983rust_ling
scoring103117213__scoring
shoring112820073__shoring
sistering101213753sistering
snoring83917203__snoring
soring74731883__s_oring
sporing104319413__sporing
staring84527053__staring
stoking123615593__stoking
stoning83717443__stoning
stoping103716623__stoping
storming11209423__storming
storying12249673__storying
stowing113315133__stowing
string75327563__st_ring
teetering10239893teetering
tentering102313213tentering
testing86021053test__ing
texturing1735223texturing
tutoring938433_tutoring
unstring9312093unst_ring
upstaring1235963upstaring
venturing1337553venturing
vesting114618683vest__ing
vetoing11309053ve_to_ing
visoring1238373vis_oring
weltering13219493weltering
westing115020273west__ing
wresting123811833wrest__ing
wrestling1336063wrest_ling
zesting174515333zest__ing

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.453394461.4
2DLD Change Limit1486412936.82621775.7
3Display Results2932930.1402092.9
 (SQL Overall)1786912937.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.