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

237 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
startling103737(None) 
starling93017121star_ling
starting93116171start_ing
dartling1039562_dartling
scantling12107232scantling
scarting113415262scart_ing
smarting113212452smart_ing
snarling92513182snar_ling
sparkling16226352sparkling
sparling112714532spar_ling
stabling112913652sta_bling
staling83925422sta__ling
stalling95116702sta_lling
stapling112813152sta_pling
starching1538592starching
staring84527052star__ing
starlings10237922star_lings
starring92312952star_ring
startlingly1542762startlingly
starveling1444262starveling
starving122510172star_ving
stating83725162sta_t_ing
sterling93615552ster_ling
tarting84222652_tart_ing
tattling9259472_tattling
turtling9238832_turtling
unstartling1242382unstartling
argling92812733__argling
bantling112612003_bantling
battling113110493_battling
brattling1236003brattling
carling103727063_car_ling
caroling113317003_caroling
carting104228283_cart_ing
castling11311233_castling
catling104819793_ca_tling
charting142614193chart_ing
chortling1535563chortling
darkling1437483_darkling
darling93418363_dar_ling
darting94020663_dart_ing
earthing12310333_earthing
earthling1346193_earthling
estating92614993esta_t_ing
farthing1538073_farthing
farting114120753_fart_ing
fatling113815683_fa_tling
flatling123410013fla_tling
garbling12249453_garbling
gargling11239203_gargling
gnarling10217603gnar_ling
hearting12513123heart_ing
hurtling12318313_hurtling
karting123716063_kart_ing
mantling112012613_mantling
marbling13179883_marbling
marling103322773_mar_ling
marting103325013_mart_ing
parling103823763_par_ling
paroling113316213_paroling
parting103527383_part_ing
partying14168893_partying
pearling11912013pear_ling
prattling1246303prattling
rattling92510873_rattling
restarting11310663restart_ing
saddling11239593s_addling
sailing83927373s_a_iling
salting84120793s_alt_ing
sampling13510643s_ampling
sandling102214413s_andling
sapling103217863s_a_pling
sating74735453s_a_t_ing
sauteing937913s_auteing
scabbling1634863scabbling
scaling103519373sca__ling
scanting113914763scant_ing
scantlings1393313scantlings
scarfing14309713scar_fing
scaring103421973scar__ing
scarphing1735243scarphing
scarping133312463scar_ping
scarring112511513scar_ring
scathing14269703sca_thing
scatting113311813sca_tting
scrawling15195583scrawling
scuttling1234243scuttling
sealing83528563sea__ling
searching1538343searching
searing83330923sear__ing
seating84130683sea_t_ing
settling978943s_ettling
shackling19286173shackling
shafting15278683shaft_ing
shambling1735593shambling
sharing113723243shar__ing
sharking163912973shar_king
sharping143011373shar_ping
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
shearling1336923shear_ling
shirting123213613shirt_ing
shorting122514803short_ing
shuttling1334293shuttling
skating123613853ska_t_ing
skirling13249063skir_ling
skirting13289393skirt_ing
slanting94115093slant_ing
slating83724653sla_t_ing
slatting94014233sla_tting
smartening1344993smartening
snaffling1643763snaffling
snailing92912973sna_iling
snarfing12358663snar_fing
snaring83920953snar__ing
snorting92613373snort_ing
soaring83521893soar__ing
sorting83221813s_ort_ing
spackling18266503spackling
spalling113213463spa_lling
spangling1336373spangling
sparging122611133spar_ging
sparing104823873spar__ing
sparking152812543spar_king
sparlings12257153spar_lings
sparring113112223spar_ring
sparteine1185483sparteine
spartina1037983spart_ina
spatting113111763spa_tting
spiraling1237953spiraling
spirting112913633spirt_ing
sporting112415463sport_ing
sprattling1363053sprattling
sprawling15175123sprawling
spurting113111633spurt_ing
stabbing13238763sta_bbing
stablings12256103sta_blings
stacking154215083sta_cking
staffing15247493sta_ffing
stagging113310513sta_gging
staging93818373sta__ging
staining9413373sta_ining
staking123919803sta__king
stalking133512223sta_lking
stamping133310963sta_mping
stanching1538083stanching
standing103413633sta_nding
stanging104013653sta_nging
staning83922243sta__ning
stargazing2193323stargazing
starlike1238813star_like
starlit71512913star_li_t
startle72511123startl__e
startled9208563startl_ed
startler8248793startl_er
startlers9236743startlers
startles82111963startl_es
starvelings1542223starvelings
stashing123511583sta_shing
statin63921473sta_t_in_
statins73719773sta_t_ins
staving113915703sta__ving
staying114017323sta__ying
stealing93416603st_ealing
steeling93615143st_eeling
stereoing1037893stereoing
sterlings10308753ster_lings
stetting93410713st_etting
stickling1647003stickling
stifling122110913st_ifling
stilling93415323st_illing
stilting93312403stilt_ing
stinting93415743stint_ing
stippling1475173stippling
stirring9299653stir_ring
stooling93113133st_ooling
stoppling1474963stoppling
storing83921123stor__ing
storming11209423stor_ming
storying12249673stor_ying
stotting92811163st_otting
straddling1343643straddling
strafing122111193st_rafing
straggling1344303straggling
straining10410563straining
stranding1149653stranding
strangling1256403strangling
strapping1436993strapping
strawing122411623st_rawing
straying122912693st_raying
streeling10189483streeling
strewing12289853st_rewing
striding102713603st_riding
striking133012233st_riking
string75327563st_r__ing
striping112612523st_riping
stripling1257783stripling
striving122611393st_riving
stroking132610943st_roking
strolling10238793strolling
strowing122310563st_rowing
stroying122410593st_roying
strutting1037003strutting
stumbling1435003stumbling
stunting92811503stunt_ing
styling112910653st__yling
swaddling1543813swaddling
swarding1359003swar_ding
swarming1458223swar_ming
swathing15248713swa_thing
swatting12309593swa_tting
swirling12249143swir_ling
tabling103216033_ta_bling
tackling153211123_tackling
tailing82923103_ta_iling
tangling101712543_tangling
taring73932283_tar__ing
tarring83318303_tar_ring
tarrying12146723_tarrying
tasting84624213_tast_ing
tatting84019523_ta_tting
tauting83316383_taut_ing
tirling83315733_tir_ling
titling83715793_t_itling
tootling9279523_tootling
trailing92916093_trailing
trawling122710783_trawling
turtlings10184873_turtlings
twattling1332693twattling
upstarting1343883upstart_ing
warbling14198943_warbling
warsling12198593_warsling
warstling1335063_warstling
wattling12258783_wattling
wrastling1335523wrastling
yearling1297883year_ling

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 Limit1486412377.56319653.7
3Display Results2372370.0932548.4
 (SQL Overall)1786912378.07922118.0
 
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.