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

190 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
restarting1131066(None) 
restating102319411resta_ting
estating92614992_esta_ting
gestating11229982gesta_ting
recharting1637212recharting
reseating102421532resea_ting
reslating102516992resla_ting
resorting10614612res_orting
restabling1337652restabling
restacking1737182restacking
restaffing1744192restaffing
restaging112410852resta_ging
restamping1565212restamping
restoring10314612restor_ing
restring91518782rest_r_ing
retarding111110652re_tarding
retasting102513412re_tasting
retorting10613272re_torting
starting93116172__starting
upstarting1343882upstarting
bestirring1343993bestirring
beswarming1843273beswarming
castrating1349773castrating
costarring1345393costarring
departing1349513de_parting
desalting1138843des_alting
descanting1446923descanting
deserting11713143des_erting
destaining1267943destaining
disparting1438933disparting
distasting1248023distasting
distorting1239583distorting
escarping1435203_escarping
escorting1237713_escorting
estraying1338293_estraying
extorting1746763_extorting
festering132413173fester_ing
frustrating1544263frustrating
gesturing1136653gestur_ing
hearting12513123he__arting
hesitating1448003hesita_ting
instarring1144063instarring
instating10812213insta_ting
lustrating1147783lustrating
misparting1538083misparting
misstarting14125203misstarting
outstarting1245013outstarting
pestering122315663pester_ing
presorting1339983pres_orting
prestamping1863653prestamping
prestoring13310303prestor_ing
pretasting13239283pre_tasting
prostrating1449393prostrating
ramparting1543893ramparting
reacting113317893re__acting
readapting1445153readapting
rearing83128783re__ar_ing
rearming111413613re__arming
reasserting1246153reasserting
reassorting1245023reassorting
rebaiting12311643re_baiting
rebating112418343re_ba_ting
reboarding1445673reboarding
recanting122414823re_canting
recasting122414233re_casting
recharging1745293recharging
recoating121317463recoa_ting
recrating121318793recra_ting
redacting13612303re_dacting
redating102620173re_da_ting
redbaiting1446263redbaiting
redrafting1545963redrafting
redshirting1643263redshirting
reearning1039053re_earning
reenacting1357353reenacting
reflating132514713refla_ting
refracting1638733refracting
regarding12149153re_garding
regearing112211413regear_ing
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regra_ting
rehearing132211763rehear_ing
rehearsing1444343rehearsing
reheating132314913rehea_ting
reinstating1248113reinsta_ting
reiterating12410493reiterating
relating92725443re_la_ting
relearning1135283relearning
remarking1638893re_marking
remating112322423re_ma_ting
reparking1638923re_parking
repasting122312843re_pasting
repeating122618983repea_ting
replanting1338523replanting
replating122217403repla_ting
reporting12513903re_porting
resailing103314253res_ailing
resaluting1137393resaluting
resawing122311433res_a_wing
resaying122512453res_a_ying
rescaling122212013resca_ling
rescoring12310603rescor_ing
resealing102115673resea_ling
researching1743423researching
resecting122816483res_ecting
resenting102619293res_enting
reserving131110643res_erving
resetting102816293res_etting
reshaping1557743resha_ping
reshaving1657273resha_ving
reshooting1436223reshooting
resifting133512093res_ifting
resighting1546073resighting
resinating11313733resinating
resisting103215313res_isting
resiting93521123res__iting
resitting103414873res_itting
resituating1247543resituating
resmelting1337263resmelting
resoaking1439373resoa_king
resonating11311263resonating
resorbing1269353res_orbing
respacing1438893respa_cing
respading1338803respa_ding
respecting1549883respecting
respiring12159903respir_ing
respiting121912863res_piting
respotting1347113respotting
respraying1636093respraying
respring111614063res_pr_ing
restart7320033restart___
restarted10410053restart_ed
restarts8310873restart__s
restation9316913resta_tion
restations10315843resta_tions
resting85031183res___ting
restituting12156563restituting
restocking1745703restocking
restoking1438193rest_oking
restrain8311703rest_rain_
restraining1247533restraining
restrains9311623rest_rains
restraint9412753rest_raint
restricting1449303restricting
restriking1548043restriking
restrings10159293rest_r_ings
restriving1448133restriving
restrung9176443rest_r_ung
restudying1543423restudying
restuffing1743163restuffing
restyling1337923rest_yling
resulting10311083res_ulting
resurging1138613res_urging
retacking1658973re_tacking
retagging1236033re_tagging
retailing103214733re_tailing
retaining102114733re_taining
retaking133114283re_ta_king
retaping113012553re_ta_ping
retargeting1343933re_targeting
retaxing162311333re_ta_xing
retearing102214253retear_ing
retesting102614603re_testing
retinting102215253re_tinting
retiring92717413re_tir_ing
retracing12313293re_tracing
retracting13311933retracting
retrying122410453re_t_rying
retting83425883re_t__ting
returning1038133re_turning
reverting132315133re_verting
rewarding14148833re_warding
rewarming15147383re_warming
rewearing132310703rewear_ing
rotating92614553r_ota_ting
scarting113415263__scarting
smarting113212453__smarting
staring84527053__star_ing
starling93017123__starling
starring92312953__starring
startling1037373__startling
starving122510173__starving
stating83725163__sta_ting
tarting84222653___tarting
unstartling1242383unstartling
unstating10711213unsta_ting
upstaring1235963upstar_ing
vesturing1337203vestur_ing
westering132112643wester_ing

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031907.92317746.2
3Display Results1901900.0902111.1
 (SQL Overall)1786911908.43621182.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.