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

200 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
stablings1225610(None) 
stabling112913651stabling_
starlings10237921starlings
ablings1038742__ablings
sailings93513252s_ailings
saplings11269802s_aplings
siblings11108122s_iblings
sparlings12257152sparlings
stabbing13238762stabbing_
stagings10378342sta_gings
staling83925422sta_ling_
stalkings14314982stalkings
stalling95116702stalling_
standings11257152standings
stapling112813152stapling_
starling93017122starling_
stealings10318852stealings
sterlings10308752sterlings
stylings12276232st_ylings
tabling103216032_tabling_
tailings93211672_tailings
ablins8316193__ablin_s
atabrines1144463atabrines
athelings1345113athelings
babblings13194373babblings
bramblings1742613bramblings
bumblings16194753bumblings
cabling124017553_cabling_
callings113613833_callings
carlings114015853_carlings
catlings113712043_catlings
cymblings1942663cymblings
dabblings15193883dabblings
darlings103710383_darlings
dealings103510703dea_lings
detailings12243923detailings
dialings10329823dia_lings
diallings1134993diallings
eanlings9128473_eanlings
enabling1138603enabling_
fabling133413623_fabling_
failings123811013_failings
fatlings12359303_fatlings
flatlings13315823flatlings
gabling113514543_gabling_
graylings1433883graylings
mailings113011923_mailings
mallings113413093_mallings
marblings14225543marblings
marlings113713493_marlings
palings103915823_pa_lings
railings93412153_railings
rattlings10235513rattlings
restabling1337653restabling_
retailings11265233retailings
rumblings14184633rumblings
sabbing123314743s_abbing_
sabeing102611863s_abeing_
sabines94318483s_ab_ines
sabins85521983s_ab_in_s
sabring102614843s_abring_
sackings15389633s_ackings
sacrings11278923s_acrings
sailing83927373s_ailing_
salinas73116093s_a_linas
salines74029413s_a_lines
saltings92811253s_altings
samplings1435553samplings
sandlings11238093sandlings
sapling103217863s_apling_
savings114412953s_a_vings
sayings113610833s_a_yings
scabbing15277193scabbing_
scabbling1634863scabbling_
scablands1443783scablands
scaling103519373sca_ling_
scannings12264823scannings
scantlings1393313scantlings
sealing83528563sea_ling_
seatings93614303sea_tings
seedlings11195953seedlings
settlings1054683settlings
shadings13327433sha_dings
shaftings16224183shaftings
shambling1735593shambling_
shauling1249393shauling_
shavelings1743503shavelings
shavings15356333sha_vings
shawling1558223shawling_
shealings13317563shealings
shearlings1443533shearlings
shielings13237123shielings
shillings13348093shillings
sibling10814423s_ibling_
skatings13326993ska_tings
skillings14246133skillings
slabbing13287783slabbing_
slammings14234123slammings
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
slings74618013s___lings
slubbings14213383slubbings
snailing92912973snailing_
snarling92513183snarling_
soarings93210393soa_rings
spacings13287043spa_cings
spaeings11276253spa_eings
spalling113213463spalling_
spankings16215003spankings
sparling112714533sparling_
spellings12296553spellings
spilings11308813s_pilings
spoolings12245393spoolings
stabiles10311403stab_iles
stabilises12116013stabilises
stabilizes21116063stabilizes
stableness1248823stableness
stablers103611153stabl_ers
stables93219073stabl__es
stablish1348343stabli_sh
stablishes1545373stablishes
stacking154215083stacking_
staffing15247493staffing_
stagging113310513stagging_
staging93818373sta_ging_
staigs75414813sta__i_gs
staining9413373staining_
stains64923653sta__in_s
staking123919803sta_king_
stalags838643sta_l_ags
stalking133512223stalking_
stallions946073stallions
staminas1048853sta_minas
stamping133310963stamping_
standing103413633standing_
stanging104013653stanging_
stangs75018163sta___ngs
stanines85115673sta_nines
staning83922243sta_ning_
staring84527053sta_ring_
starring92312953starring_
starting93116173starting_
startling1037373startling_
starvelings1542223starvelings
starving122510173starving_
stashing123511583stashing_
stating83725163sta_ting_
statins73719773sta_tin_s
staving113915703sta_ving_
staying114017323sta_ying_
steadings11307083steadings
stealing93416603stealing_
steeling93615143steeling_
steevings13284443steevings
sterling93615553sterling_
stibines1038153stib_ines
stifling122110913stifling_
stilling93415323stilling_
stings76220183st___ings
stipplings1582373stipplings
stirrings10224693stirrings
stobbing13227243stobbing_
stockings16296093stockings
stooling93113133stooling_
strappings1543353strappings
strings84617133st__rings
stripings12215203stripings
striplings1344183striplings
stubbing13237453stubbing_
studdings1242933studdings
stuffings16233493stuffings
stumbling1435003stumbling_
styling112910653st_yling_
subbings13238483s_ubbings
sublines10315783s_ublines
subrings11229883s_ubrings
sucklings16225113sucklings
swabbing16246453swabbing_
swellings13296103swellings
tabbing123611913_tabbing_
tabuing10308893_tabuing_
tacklings16235853_tacklings
taglines92210833_taglines
tailing82923103_tailing_
takings124512573_ta_kings
talkings13358403_talkings
tannings9268633_tannings
tappings13267713_tappings
tattings9408823_tattings
tilings84212793_t_ilings
toolings9248473_toolings
tubings10336483_tub_ings
tumblings14184843tumblings
weaklings1794003weaklings
weanlings1394413weanlings
whalings15256763wha_lings
yealings12257703yea_lings
yeanlings1393693yeanlings
yearlings1384203yearlings

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.423422437.4
2DLD Change Limit1486412007.08020994.5
3Display Results2002000.0932150.5
 (SQL Overall)1786912007.59623524.4
 
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.