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

181 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
sprawled143452(None) 
scrawled1445921scrawled
sprawler1334651sprawler
brawled133910122_brawled
crawled133710402_crawled
drawled12368342_drawled
prawned1346742_prawned
prowled13309912_prowled
scrawler1345892scrawler
shawled1437772s_hawled
spalled103113132sp_alled
sparkled15317732sparkled
spawned13316802sp_awned
spiraled1137732spira_led
spiralled1244402spiralled
spraddled14203462spraddled
sprained1138432sprained
sprattled1263312sprattled
sprawl11188062sprawl__
sprawlers1433902sprawlers
sprawlier1443292sprawlier
sprawls12176372sprawl_s
sprawly15166042sprawl_y
sprayed13398902spra_yed
strawed114813612straw_ed
trawled113411522_trawled
appalled1344813appalled
bawled124415693__bawled
becrawled1743123becrawled
brailed103914013_brailed
brawler124310233_brawler
craaled10339423_craaled
cradled113410813_cradled
crawler123510463_crawler
derailed102410403derailed
drawler11338593_drawler
growled12278173_growled
kraaled12254983_kraaled
muraled10410833mura_led
muralled1136423muralled
paled85538723_p_a_led
palled94625163_p_alled
parled94626293_p_arled
paroled104217633_paroled
pawed115725613_p_aw_ed
pawned124513283_p_awned
pealed95322813_pea_led
pearled10411553_pearled
praised104214813_praised
pranced123714043_pranced
pranged114512553_pranged
pranked143712093_pranked
prated94924923_pra_ted
prattled11246533_prattled
prawner1246803_prawner
prayed124815433_pra_yed
prilled104713003_prilled
prowler123310013_prowler
pshawed16103033pshaw_ed
railed74727543__railed
sailed74327763s__ailed
sawed95628403s__aw_ed
scaled94822443s_ca_led
scowled13398193s_cowled
scrabbled16154973scrabbled
scragged1335823scragged
scrambled16164813scrambled
scrammed1555003scrammed
scraped124313133scra_ped
scrapped1556533scrapped
scrawl11208093scrawl__
scrawlers1434753scrawlers
scrawlier1443903scrawlier
scrawls12177283scrawl_s
scrawly15197193scrawl_y
screwed135710663screw_ed
scrolled1137053scrolled
scrupled1335823scrupled
sealed74328363s_ea_led
seaweed11108813s_eaweed
sepaled10510593sepa_led
sepalled1156903sepalled
shaled105023953s_ha_led
shauled1148793s_hauled
shawed134817233s_haw_ed
shoaled113810973shoa_led
shrewed14589853shrew_ed
shrilled1246863shrilled
skoaled12226063skoa_led
snailed83811923s_nailed
snarled83612363s_narled
snawed104813733s_naw_ed
spaced114517253sp_a_ced
spackled17297803spackled
spaded103816753sp_a_ded
spaed85522273sp_a__ed
spale74929213sp_a_le_
spales84728103sp_a_les
spaller92713473sp_aller
spammed14348523sp_ammed
spangled1236153spangled
spanked143111733sp_anked
spanned104111223sp_anned
sparable121611983sparable_
sparables13167163sparables
spared95427493sp_a_red
sparged113512763sp_arged
sparked143513143sp_arked
sparkle133710213sparkle_
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparred104512863sp_arred
spasmed12296993sp_asmed
spathed134013183sp_athed
spatted104014143sp_atted
spawner12347363sp_awner
spayed124213613sp_a_yed
speaned103411523spea_ned
speared104314423spea_red
speckled17255833speckled
speeled103712453sp_eeled
speiled104412123sp_eiled
spelled103714733sp_elled
spewed125512333sp_ew_ed
spieled104811883sp_ieled
spiled94621993sp__iled
spilled103613623sp_illed
spindled12287643spindled
spiracle1255803spiracle_
spiracles1345663spiracles
splashed1435593splashed
splatted11356743splatted
splayed13357813spla_yed
spoiled104811353sp_oiled
spooled104613523sp_ooled
spraddle12194163spraddle_
spraddles13194283spraddles
sprattle1054763sprattle_
sprattles1174883sprattles
sprawliest1543573sprawliest
sprawling15175123sprawling
sprayer12369043spra_yer
sprigged13316223sprigged
springed123911323springed
sprinkled1633713sprinkled
sprinted113411163sprinted
spritzed2044803spritzed
sprouted1136393sprouted
spruced12307533spr_uced
spurgalled1441763spurgalled
squalled1835943squalled
squawked2543013squawked
stabled103514953s_tabled
staled74728103s_ta_led
stalled83515683s_talled
stapled103613703s_tapled
startled9208563startled
straddled12205023straddled
strafed114413333stra_fed
straggled12296853straggled
strained9412253strained
straked125415343stra_ked
stranded102710813stranded
strangled11268983strangled
strapped1357823strapped
strawier1137493strawier
strayed114513283stra_yed
streeled9267863streeled
strewed115811343strew_ed
strolled937813strolled
strowed115312143strow_ed
thralled1245803thralled
thrawed1435583thraw_ed
trailed83415673_trailed
trawler104011903_trawler
trawley13317303_trawley
upraised11167413upraised
uprated103213323upra_ted
wawled133811703__wawled
yawled13459983__yawled

Search took 10 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621818.50017195.5
3Display Results1811810.0762381.6
 (SQL Overall)1786911819.02919790.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.