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 “sprawly” 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
sprawly1516604(None) 
scrawly15197191scrawly
sprawl11188061sprawl_
sprawls12176371sprawls
brawly144312352_brawly
crawly144610762_crawly
drawly134910722_drawly
rawly115115832__rawly
scrawl11208092scrawl_
scrawls12177282scrawls
scrawny15213942scrawny
sparely123410672sparely
sparkly16348132sparkly
spirally1348022spirally
sprawled1434522sprawled
sprawler1334652sprawler
spray106720062spra__y
spryly1435512spr_yly
strawy1210312822straw_y
astrally1148883astrally
aurally10310543aurally
brawl106217963_brawl_
brawls115214333_brawls
brawny144710603_brawny
caraway1538133caraway
crawl104916713_crawl_
crawls114712083_crawls
curably142010773curably
drably123511613_drably
drawl95516013_drawl_
drawls105511393_drawls
durably13229053durably
faraway1645413faraway
grayly13287963_grayly
growly13499173_growly
gyrally1435583gyrally
jurally1736963jurally
morally12411493morally
operably1557093operably
orally93113593_orally
pally105727123_p_ally
paly95835533_p_a_ly
partly116315473_partly
patly105020583_p_atly
pawky173810153_p_awky
pawl95123263_p_awl_
pawls105617663_p_awls
pearly116414843_pearly
prawn105312433_praw_n
prawns11509023_prawns
pray96331533_pra__y
primly13439623_primly
prowl105615123_prowl_
prowls115511083_prowls
rally84725903__rally
rurally1038303rurally
sadly94519123s__adly
salably121610743salably
sally85129713s__ally
sawfly1535133s__awfly
scaly104718723s_ca_ly
scarily12311703scarily
scrabbly17164623scrabbly
scraggly15294143scraggly
scraggy14304583scraggy
scrappy16234473scrappy
scrawled1445923scrawled
scrawler1345893scrawler
screwy14659463screw_y
seaway12309993s_eaway
separably1655773separably
serail64222673serail_
serails73318363serails
seral56336383sera_l_
serially11912843serially
shaly114322863s_ha_ly
sharply15406833sharply
shawl116217573s_hawl_
shawls125411973s_hawls
shoaly124010773shoa_ly
shrewdly1842543shrewdly
shrilly13318563shrilly
sizably2136613sizably
slowly1237153s_lowly
smartly12497433smartly
snarly93815003s_narly
sorely94618013sor_ely
sorrily1039833sorrily
sortably1338803sortably
sovranly1443453sovranly
spacey136212533sp_acey
spacy125415623sp_a_cy
spail74921553sp_ail_
spails84817823sp_ails
spale74929213sp_a_le
spall74919303sp_a_ll
spalls84217343sp_alls
spangly1336473spangly
sparable121611983sparable
sparkily1735023sparkily
sparkle133710213sparkle
sparky154511523sp_arky
sparry115111303sp_arry
sparsely1335123sparsely
spawn107811713sp_aw_n
spawns11577923sp_awns
spay96631663sp_a__y
spicily1438653spicily
spikily1635873spikily
spinally1338023spinally
spindly13257383spindly
spiracle1255803spiracle
spiral83715343spira_l_
spirals93212513spira_ls
splashy1543553splashy
splay105816043spla__y
sporal82915453spora_l_
sportily1337733sportily
spraddle12194163spraddle
sprag86418693spra__g
sprags95715823spra_gs
sprain83614863spra_in
sprains93013593sprains
sprang95713523spra_ng
sprangs104610053sprangs
sprat76635973spra__t
sprats85819933spra_ts
sprattle1054763sprattle
sprawlers1433903sprawlers
sprawlier1443293sprawlier
sprawling15175123sprawling
sprayed13398903sprayed
sprayer12369043sprayer
sprays115913643spra_ys
spriggy14374213spriggy
springy13359663springy
sprucely1543123sprucely
sprucy13356323spr_ucy
spry96819123spr___y
squally1937673squally
squatly1946433squatly
stably113314123s_tably
starkly14277033starkly
straggly13355563straggly
straitly1136563straitly
strappy14205263strappy
straw813321293straw__
strawed114813613strawed
straws98718673straw_s
stray88525573stra__y
suably112814533s_uably
superably1648883superably
sural55931263sura_l_
surely93816463sur_ely
surlily10310003surlily
surly85124433sur__ly
thrawnly1741793thrawnly
trawl84915873_trawl_
trawley13317303_trawley
trawls94412393_trawls
virally1339653virally

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271616.65620136.3
3Display Results1611610.0602683.3
 (SQL Overall)1786911617.15224984.8
 
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.