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

161 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
sprawling1517512(None) 
scrawling15195581scrawling
brawling143210042_brawling
crawling143110512_crawling
drawling13318672_drawling
prawning1446962_prawning
prowling1449992_prowling
shawling1558222s_hawling
spalling113213462sp_alling
sparkling16226352sparkling
sparling112714532sp_arling
spawning14296912sp_awning
spiraling1237952spira_ling
spiralling1343962spiralling
spraddling1542312spraddling
spraining1248152spraining
sprattling1363052sprattling
sprawlier1443292sprawlier
spraying14299882spra_ying
strawing122411622straw_ing
trawling122710782_trawling
appalling1444923appalling
bawling133813863__bawling
becrawling1843613becrawling
brailing113514793_brailing
craaling112711353_craaling
cradling122411453_cradling
derailing112011313derailing
drawing123812053_draw_ing
grayling1338003_grayling
growling1348163_growling
kraaling13186663_kraaling
paling93530133_p_a_ling
palling104024483_p_alling
parawing14310583paraw_ing
parling103823763_p_arling
paroling113316213_paroling
pawing124519553_p_aw_ing
pawning134711413_p_awning
pealing104123203_pea_ling
pearling11912013_pearling
praising113214563_praising
praline93019743_pra_line
prancing132612163_prancing
pranging123012723_pranging
pranking153813383_pranking
prating103424453_pra_ting
prattling1246303_prattling
praying133717323_pra_ying
prilling113413413_prilling
pshawing1733523pshaw_ing
railing83325643__railing
sailing83927373s__ailing
sapling103217863s__apling
sawing104323813s__aw_ing
scaling103519373s_ca_ling
scowling1458293s_cowling
scrabbling1742853scrabbling
scragging1435273scragging
scrambling1743473scrambling
scramming1634883scramming
scraping133310863scra_ping
scrapping1635743scrapping
scrawlier1443903scrawlier
screwing14288233screw_ing
scrolling12187803scrolling
scrupling1435193scrupling
sealing83528563s_ea_ling
shauling1249393s_hauling
shawing143514883s_haw_ing
shealing123415463shea_ling
shearling1336923shearling
shoaling123111753shoa_ling
shrewing15228093shrew_ing
shrilling13307693shrilling
skoaling13227213skoa_ling
snailing92912973s_nailing
snarling92513183s_narling
snawing113612483s_naw_ing
spacing123614493sp_a_cing
spackling18266503spackling
spading113114383sp_a_ding
spaeing103413543sp_a_eing
spamming15317603sp_amming
spangling1336373spangling
spanking153911973sp_anking
spanning113311083sp_anning
sparging122611133sp_arging
sparing104823873sp_a_ring
sparking152812543sp_arking
sparlings12257153sp_arlings
sparring113112223sp_arring
spasming13227203sp_asming
spatting113111763sp_atting
spaying133014623sp_a_ying
speaking153212493spea_king
speaning113512243spea_ning
spearing113216103spea_ring
speckling18235583speckling
speeling112713123sp_eeling
speiling113612973sp_eiling
spelling113315233sp_elling
spewing133110453sp_ew_ing
spieling113212523sp_ieling
spiling102919703sp__iling
spilling113113943sp_illing
spindling13136273spindling
splashing1535703splashing
splatting1235983splatting
splaying14219303spla_ying
spoiling112911553sp_oiling
spooling113212563sp_ooling
sprain83614863spra__in_
sprains93013593spra__ins
sprang95713523spra___ng
sprawl11188063sprawl___
sprawled1434523sprawl_ed
sprawler1334653sprawl_er
sprawlers1433903sprawlers
sprawliest1543573sprawliest
sprawls12176373sprawl__s
sprawly15166043sprawl__y
spreading1339653spreading
sprigging1435893sprigging
spring94526013spr___ing
springing1338743springing
sprinkling1743823sprinkling
sprinting12310033sprinting
spritzing2135393spritzing
sprouting1236943sprouting
sprucing1336893spr_ucing
spurgalling1551723spurgalling
squalling1935173squalling
squawking2642433squawking
stabling112913653s_tabling
staling83925423s_ta_ling
stalling95116703s_talling
stapling112813153s_tapling
starling93017123s_tarling
startling1037373startling
stealing93416603stea_ling
straddling1343643straddling
strafing122111193stra_fing
straggling1344303straggling
straining10410563straining
stranding1149653stranding
strangling1256403strangling
strapping1436993strapping
straying122912693stra_ying
streeling10189483streeling
strewing12289853strew_ing
stripling1257783stripling
strolling10238793strolling
strowing122310563strow_ing
thralling13256833thralling
thrawing1535963thraw_ing
trailing92916093_trailing
upraising1237263upraising
uprating11311113upra_ting
wawling143810963__wawling
yawling14369183__yawling

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.440406115.9
2DLD Change Limit1486411618.37317752.4
3Display Results1611610.0802012.5
 (SQL Overall)1786911618.89320093.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.