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

196 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
strolling1023879(None) 
scrolling12187801scrolling
trolling93212491_trolling
carolling1259412carolling
drolling103510762_drolling
enrolling1087732enrolling
outrolling1137532outrolling
patrolling1345702patrolling
rerolling102210372rerolling
rolling83620412__rolling
shrilling13307692shrilling
stalling95116702st_alling
stilling93415322st_illing
stooling93113132st_ooling
streeling10189482streeling
stripling1257782stripling
stroking132610942stro_king
stropping1436932stropping
strouding1136372strouding
strowing122310562stro_wing
stroying122410592stro_ying
tolling83418562_t_olling
trilling92815962_trilling
trollings10286692_trollings
trollying1354052_trollying
unrolling1078562unrolling
bolling103820883__bolling
broiling113112013_broiling
caroling113317003caro_ling
controlling1445423controlling
dolling93817373__dolling
drilling103311983_drilling
drooling102610423_drooling
enscrolling1452283enscrolling
extolling1744623extolling
frilling123011493_frilling
grilling103811533_grilling
growling1348163_growling
inscrolling1452443inscrolling
knolling13206893_knolling
logrolling1243063logrolling
lolling83415783__lolling
outpolling1346213outpolling
paroling113316213paro_ling
perilling12410003perilling
pistolling1345353pist_olling
polling102920383__polling
prilling113413413_prilling
prowling1449993_prowling
repolling122110203repolling
rilling84023623__rilling
roiling83220453__roiling
rolfing113710653__rolfing
rollings9419953__rollings
schilling15286393schilling
schooling1546943schooling
scolding12278913s_colding
scowling1458293s_cowling
scrawling15195583scrawling
scrooping1446593scrooping
scrouging1335263scrouging
scrupling1435193scrupling
sculling112910993s_culling
selling83225833s__elling
shelling123515213s_helling
shilling123315383s_hilling
shoaling123111753s_hoaling
shooling123012563s_hooling
shroffing1943313shroffing
shrouding1434753shrouding
skilling132911333s_killing
skoaling13227213s_koaling
skulling13258103s_kulling
smelling113712733s_melling
snelling93913563s_nelling
snooling93013473s_nooling
snoozling19314343snoozling
soiling83422323s__oiling
soling74226823s__o_ling
soloing82813803s__oloing
solving112910853s__olving
spalling113213463s_palling
spelling113315233s_pelling
spilling113113943s_pilling
spiralling1343963spiralling
spoiling112911553s_poiling
spooling113212563s_pooling
sprawling15175123sprawling
sprouting1236943sprouting
squalling1935173squalling
stabling112913653st_abling
staling83925423st__aling
stalking133512223st_alking
stapling112813153st_apling
starling93017123st_arling
startling1037373startling
starveling1444263starveling
stealing93416603st_ealing
steamrolling1551413steamrolling
steeling93615143st_eeling
sterling93615553st_erling
stickling1647003stickling
stifling122110913st_ifling
stilting93312403st_ilting
stippling1475173stippling
stobbing13227243st_obbing
stocking152912503st_ocking
stodging11277463st_odging
stoking123615593st_o_king
stollen747593st_ollen_
stollens835293st_ollens
stomping13309763st_omping
stoning83717443st_o_ning
stooging102810043st_ooging
stooking132711143st_ooking
stooping113012363st_ooping
stoping103716623st_o_ping
stopping133611413st_opping
stoppling1474963stoppling
storing83921123st_o_ring
storming11209423st_orming
storying12249673st_orying
stotting92811163st_otting
stowing113315133st_o_wing
straddling1343643straddling
strafing122111193str_afing
straggling1344303straggling
straining10410563straining
stranding1149653stranding
strangling1256403strangling
strapping1436993strapping
strawing122411623str_awing
straying122912693str_aying
streaking142010323streaking
streaming12239653streaming
streeking14217453streeking
stressing1038333stressing
strewing12289853str_ewing
striating10914193striating
strickling1744953strickling
striding102713603str_iding
striking133012233str_iking
string75327563str___ing
stringing1139753stringing
striping112612523str_iping
striplings1344183striplings
stripping1436493stripping
striving122611393str_iving
stroll6311603stroll___
strolled937823stroll_ed
stroller848183stroll_er
strollers937563strollers
strolls739183stroll__s
strong74914883stro___ng
stroudings1242743stroudings
struggling1342503struggling
strumming1454413strumming
strunting1037873strunting
strutting1037003strutting
stumbling1435003stumbling
styling112910653st__yling
swelling123212753s_welling
swilling123511933s_willing
symbolling1842983symbolling
telling83321093_t_elling
tholing112812333_tho_ling
thralling13256833thralling
thrilling13276693thrilling
tilling83522783_t_illing
toiling83219023_t_oiling
toling73926123_t_o_ling
tooling82918313_t_ooling
tootling9279523_tootling
trailing92916093_trailing
trawling122710783_trawling
trebling1139873_trebling
trifling122411503_trifling
tripling112712553_tripling
troaking133310973_troaking
trocking153612423_trocking
troking123514103_tro_king
trolleying1442553_trolleying
trollied935903_trollied
trollies8310233_trollies
tromping13319603_tromping
trooping112710283_trooping
trothing122410843_trothing
trotline8310023_trotline
trotting92510913_trotting
troubling1234943_troubling
trouping11249503_trouping
troweling1376363_troweling
trowelling1484913_trowelling
trowing113413703_tro_wing
twilling12268673_twilling
vitriolling1561923vitriolling

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.453394461.4
2DLD Change Limit1486411967.75019179.5
3Display Results1961960.0962041.7
 (SQL Overall)1786911968.29921531.6
 
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.