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

199 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
stalkings1431498(None) 
stalking133512221stalking_
talkings13358401_talkings
calkings15289222_calkings
sackings15389632s_ackings
saltings92811252s_altings
spankings16215002spankings
stablings12256102stablings
stacking154215082stacking_
stagings10378342sta_gings
staking123919802sta_king_
staling83925422stal_ing_
stalling95116702stalling_
standings11257152standings
starlings10237922starlings
stealings10318852steal_ings
stockings16296092stockings
stylings12276232styl_ings
takings124512572_ta_kings
talking123815822_talking_
walkings16327312_walkings
alkines114415733__alkines
askings12519173__askings
backings174012213_backings
bakings144312023_ba_kings
balking143717353_balking_
bankings15489403_bankings
blackings18316763blackings
calking144617783_calking_
calkins133814873_calkin_s
callings113613833_callings
catlings113712043catl_ings
caulkings1633353caulkings
chalking183310063chalking_
crackings18346843crackings
dealings103510703deal_ings
dialings10329823dial_ings
diallings1134993diallings
erlkings1333563_erlkings
fatlings12359303fatl_ings
gaskings14427473_gaskings
hawkings19336133_hawkings
lakings124713513_la_kings
makings145413163_ma_kings
malkins133311803_malkin_s
mallings113413093_mallings
markings153410243_markings
maskings15448753_maskings
packings174310063_packings
palings103915823_pal_ings
parkings153610683_parkings
plankings16326113plankings
rankings13389173_rankings
sacking144122703s_acking_
sacrings11278923s_acrings
sailings93513253s_ailings
salinas73116093s_al_inas
salines74029413s_al_ines
salpinges1244523s_alpinges
saltines82917793s_altines
salting84120793s_alting_
salving113913153s_alving_
saplings11269803s_aplings
savings114412953s_a_vings
sayings113610833s_a_yings
scalding12339393scalding_
scaling103519373scal_ing_
scalping133410453scalping_
scannings12264823scannings
scoldings13224133scoldings
sculking15307913sculking_
sealing83528563seal_ing_
sealskins1343253sealskin_s
seatings93614303sea_tings
settlings1054683settl_ings
shacking184014083shacking_
shadings13327433sha_dings
shaftings16224183shaftings
shaking153317253sha_king_
shanking163612283shanking_
sharking163912973sharking_
shavings15356333sha_vings
shealings13317563sheal_ings
shelvings16283823shelvings
shillings13348093shillings
shuckings19273853shuckings
siblings11108123sibl_ings
silking123715593s_ilking_
skanking12288743skanking_
skatings13326993ska_tings
skillings14246133skillings
skulking12245903skulking_
slacking153914133slacking_
slaking123717473sla_king_
slammings14234123slammings
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
slings74618013s__l_ings
smacking173510763smacking_
smaltines1136993smaltines
smockings18264283smockings
snacking153411703snacking_
snaking123915303sna_king_
soaking123116613soa_king_
soarings93210393soa_rings
spacings13287043spa_cings
spaeings11276253spa_eings
spalling113213463spalling_
spanking153911973spanking_
sparking152812543sparking_
sparlings12257153sparlings
speakings16345933speakings
spellings12296553spellings
spilings11308813spil_ings
stabbing13238763stabbing_
stabling112913653stabling_
staffing15247493staffing_
stagging113310513stagging_
staging93818373sta_ging_
staigs75414813sta__i_gs
staining9413373staining_
stains64923653sta__in_s
stalags838643stal__ags
stalkers12369853stalk_ers
stalkier1257073stalki_er
stalkiest1347913stalkiest
stalkily1534823stalki_ly
stalkless1333723stalkless
stalks104614553stalk___s
stallions946073stallions
staminas1048853sta_minas
stamping133310963stamping_
standing103413633standing_
stanging104013653stanging_
stangs75018163sta___ngs
stanines85115673sta_nines
staning83922243sta_ning_
stapling112813153stapling_
staring84527053sta_ring_
starling93017123starling_
starring92312953starring_
starting93116173starting_
starving122510173starving_
stashing123511583stashing_
stating83725163sta_ting_
statins73719773sta_tin_s
staving113915703sta_ving_
staying114017323sta_ying_
steadings11307083steadings
stealing93416603steal_ing_
steeking133411353steeking_
steevings13284443steevings
sterlings10308753sterlings
sticking153513463sticking_
stilling93415323stilling_
stilting93312403stilting_
stings76220183st___ings
stinking133113543stinking_
stirrings10224693stirrings
stocking152912503stocking_
stoking123615593st_oking_
stooking132711143stooking_
strappings1543353strappings
streakings15235303streakings
striking133012233striking_
strings84617133st__rings
stripings12215203stripings
stroking132610943stroking_
studdings1242933studdings
stuffings16233493stuffings
styling112910653styl_ing_
sucklings16225113sucklings
sulking124514313s_ulking_
swanking16399963swanking_
swellings13296103swellings
tacking144421483_tacking_
tacklings16235853_tacklings
tailings93211673_tailings
taking114725953_ta_king_
takins105117403_ta_kin_s
talcing103111633_talcing_
talcking1567083_talcking_
talkies113415733_talki_es
talkiness1356913_talkiness
tanking123918793_tanking_
tankinis12245913_tankinis
tannings9268633_tannings
tappings13267713_tappings
tasking124616323_tasking_
tattings9408823_tattings
tickings15368583_tickings
tilings84212793_til_ings
trackings16247543trackings
uptalking1643353uptalking_
walking154013303_walking_
weaklings1794003weaklings
whalings15256763whal_ings
yealings12257703yeal_ings

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 Limit1486411997.04621095.8
3Display Results1991990.0962072.9
 (SQL Overall)1786911997.59523527.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.