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 “stalling” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
stalling9511670(None) 
spalling113213461spalling
stabling112913651stabling
staling83925421sta_ling
stalking133512221stalking
stapling112813151stapling
starling93017121starling
stilling93415321stilling
balling104424762_balling
calling103826772_calling
dialling10310782dialling
falling113621582_falling
galling93921962_galling
installing1146402installing
lalling83519622_lalling
malling103623662_malling
metalling1249592metalling
palling104024482_palling
sailing83927372s_ailing
sallying12309852s_allying
salting84120792s_alting
salving113913152s_alving
sapling103217862s_apling
scalding12339392scalding
scaling103519372sca_ling
scalping133410452scalping
sculling112910992sculling
sealing83528562sea_ling
selling83225832s_elling
shauling1249392shauling
shawling1558222shawling
shelling123515212shelling
shilling123315382shilling
skilling132911332skilling
skulling13258102skulling
smelling113712722smelling
snailing92912972snailing
snarling92513182snarling
snelling93913562snelling
sparling112714532sparling
spelling113315232spelling
spilling113113942spilling
squalling1935172squalling
stabbing13238762stabbing
stablings12256102stablings
stacking154215082stacking
staffing15247492staffing
stagging113310512stagging
staging93818372sta_ging
staining9413372staining
staking123919802sta_king
stalkings14314982stalkings
stallion837512stallion
stallions946072stallions
stamping133310962stamping
standing103413632standing
stanging104013652stanging
staning83922242sta_ning
staring84527052sta_ring
starlings10237922starlings
starring92312952starring
starting93116172starting
startling1037372startling
starving122510172starving
stashing123511582stashing
stating83725162sta_ting
staving113915702sta_ving
staying114017322sta_ying
stealing93416602stealing
steeling93615142steeling
sterling93615552sterling
stifling122110912stifling
stilting93312402stilting
stooling93113132stooling
strolling10238792strolling
styling112910652st_yling
swelling123212752swelling
swilling123511932swilling
tabling103216032_tabling
tailing82923102_tailing
talcing103111632_talcing
talking123815822_talking
tallying12318832_tallying
telling83321082_telling
tilling83522782_tilling
tolling83418562_tolling
totalling1036522totalling
vialling1237222vialling
walling113520972_walling

Search took 5 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 Filter1786911210590.393454684.5
2DLD Change Limit121059893.78032026.2
3Display Results89890.0302966.7
 (SQL Overall)178691894.20342515.1
 
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.