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

261 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
sprawls1217637(None) 
scrawls12177281scrawls
sprawl11188061sprawl_
sprawly15166041sprawly
brawls115214332_brawls
crawls114712082_crawls
drawls105511392_drawls
pawls105617662_p_awls
prawns11509022_prawns
prowls115511082_prowls
scrawl11208092scrawl_
scrawly15197192scrawly
serails73318362serails
shawls125411972s_hawls
spails84817822sp_ails
spalls84217342sp_alls
spawns11577922sp_awns
spirals93212512spira_ls
sprags95715822spra_gs
sprains93013592sprains
sprangs104610052sprangs
sprats85819932spra_ts
sprawled1434522sprawled
sprawler1334652sprawler
sprawlers1433902sprawlers
sprays115913642spra_ys
straws98718672straw_s
trawls94412392_trawls
appalls11337743appalls
appals104812943appa_ls
astrals75515243astra_ls
awls75926093___awls
bawls105719323__bawls
becrawls1543623becrawls
borals86721913bora_ls
brails84621293_brails
brawl106217963_brawl_
brawly144312353_brawly
brawns115614083_brawns
braws106425193_braw_s
corals85325143cora_ls
craals84113303_craals
crawl104916713_crawl_
crawly144610763_crawly
craws105723123_craw_s
derails84216393derails
drails74716953_drails
drawl95516013_drawl_
drawly134910723_drawly
draws95119373_draw_s
espials937093espia_ls
ferals94216643fera_ls
frails93716473_frails
gorals76917653gora_ls
graals74112913_graals
grails77518783_grails
growls104711113_growls
kraals10378433_kraals
morals85324643mora_ls
murals84016763mura_ls
narwals1036983narwals
opals75718353op_a_ls
orals55826483_ora_ls
pails75833063_p_ails
palls74332563_p_alls
pals66951353_p_a_ls
parols84722613_parols
pawl95123263_p_awl_
pawns108818133_p_awns
paws96038183_p_aw_s
peals75235493_pea_ls
pearls84715393_pearls
praams10459643_praams
prahus11458243_prahus
prams96125513_pra_ms
prangs94816233_prangs
pranks124814723_pranks
praos74923563_pra_os
prases84429023_prases
prates84633163_prates
prats76333393_pra_ts
praus74621753_pra_us
prawn105312433_praw_n
praxes156215183_praxes
praxis154012253_praxis
prays105022433_pra_ys
prills84015613_prills
prowl105615123_prowl_
prows106327013_prow_s
pshaws14435703pshaw_s
rails55937403__rails
rawly115115833__rawly
raws75238213__raw_s
sabals84618863saba_ls
sacrals93311793sacra_ls
sails55738103s__ails
salals65120083sala_ls
sals46851673s__a_ls
sarans64224433sara_ns
sarapes94617753sarapes
sauls55128123s__auls
saws75839483s__aw_s
scalls84218203s_calls
scowls11549593s_cowls
scrags95713803scra_gs
scrams105216623scra_ms
scrapes116217663scrapes
scraps106017243scra_ps
scrawled1445923scrawled
scrawler1345893scrawler
scrawlers1434753scrawlers
scrawny15213943scrawny
screws115513893screw_s
scrolls938063scrolls
seals54839703s_ea_ls
sepals85217383sepa_ls
seracs84418573sera_cs
serail64222673serail_
serais64326133sera_is
seral56336383sera_l_
serapes95218103serapes
seraphs12408093seraphs
serials73919753serials
serows96016393serow_s
servals103410753servals
shauls94913113s_hauls
shawl116217573s_hawl_
shawms14579563s_hawms
shaws116226263s_haw_s
sheals94420643shea_ls
shoals94215793shoa_ls
shrews129313923shrew_s
shrills10389933shrills
sials54227243s_ia_ls
sisals63013573sisa_ls
skoals10438243skoa_ls
slaws85222713s_law_s
smalls84514123s_malls
snails64816653s_nails
snarls64016873s_narls
snaws86116363s_naw_s
sopranos1046433sopranos
soras55041013sora__s
sorels63921163sor_els
sorrels7310723sorrels
spaces104722633sp_aces
spades94222583sp_ades
spaes76029973sp_a_es
spahis11310383sp_ahis
spail74921553sp_ail_
spaits85017473sp_aits
spale74929213sp_a_le
spales84728103sp_ales
spall74919303sp_a_ll
spams94922193sp_a_ms
spanks124514123sp_anks
spans74528733sp_a_ns
sparable121611983sparable
sparables13167163sparables
sparely123410673sparely
sparers94519613sparers
spares84834553sp_ares
sparges104016343sparges
sparids103512123sparids
sparkle133710213sparkle
sparkles143210493sparkles
sparkly16348133sparkly
sparks124616363sp_arks
spars75431543sp_a_rs
spas67036723sp_a__s
spasms10418973sp_asms
spates85028173sp_ates
spats75031383sp_a_ts
spawn107811713sp_aw_n
spays105520513sp_a_ys
speaks125114583spea_ks
speans85417143spea_ns
spears84019473spea_rs
speels85116393sp_eels
speils84116223sp_eils
spells84617683sp_ells
spews105015923sp_ew_s
spiels85317953sp_iels
spills84717463sp_ills
spinals93911863spinals
spinels94512443spinels
spiracle1255803spiracle
spiracles1345663spiracles
spiraeas10286233spiraeas
spiral83715343spira_l_
spirally1348023spirally
spirants1088283spirants
spitals93011593spitals
splakes1349673splakes
splats84817303spla_ts
splays114910873spla_ys
spoils84614533sp_oils
spools85115913sp_ools
sporal82915453spora_l_
spraddle12194163spraddle
spraddles13194283spraddles
sprag86418693spra__g
sprain83614863spra_in
sprang95713523spra_ng
sprat76635973spra__t
sprattle1054763sprattle
sprattles1174883sprattles
sprawlier1443293sprawlier
sprawliest1543583sprawliest
sprawling15175123sprawling
spray106720063spra__y
sprayed13398903sprayed
sprayer12369043sprayer
sprayers13367053sprayers
spreads1039763spreads
sprees85620643spr_ees
sprigs94814773spr_igs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533spr_its
sprouts949983sprouts
spruces113810503spruces
sprues84515763spr_ues
sprugs94010173spr_ugs
spryly1435513spr_yly
spurgalls1243093spurgalls
squalls1647313squalls
squawks23294883squawks
squaws18438783squaw_s
stalls64019933s_talls
steals64020063stea_ls
strafes104516003strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strands83711953strands
straps87721783stra_ps
strass67117223stra_ss
stratas73013583stratas
straths102711723straths
stratus73011733stratus
straw813321293straw__
strawed114813613strawed
strawy1210312823straw_y
strays96417933stra_ys
streels73811343streels
strews96817103strew_s
strolls739183strolls
strows96718273strow_s
surahs94515543sura_hs
sural55931263sura_l_
suras55336333sura__s
swails94913123s_wails
thralls10299043thralls
thraws129211103thraw_s
trails64622513_trails
trawl84915873_trawl_
uprates93814863uprates
wawls115416473__wawls
yawls114613603__yawls

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.390458182.1
2DLD Change Limit1340272616.83019623.3
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.31324434.7
 
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.