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

354 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
sprawl1118806(None) 
scrawl11208081scrawl
sprawls12176371sprawls
sprawly15166041sprawly
brawl106217962_brawl
crawl104916712_crawl
drawl95516012_drawl
pawl95123262_p_awl
prawn105312432_prawn
prowl105615122_prowl
scrawls12177272scrawls
scrawly15197182scrawly
serail64222672serail
seral56336382sera_l
shawl116217572s_hawl
spail74921552sp_ail
spall74919302sp_all
spawn107811712sp_awn
spiral83715342spira_l
sporal82915452spora_l
sprag86418692spra_g
sprags95715822sprags
sprain83614862sprain
sprang95713522sprang
sprat76635972spra_t
sprats85819932sprats
sprawled1434512sprawled
sprawler1334642sprawler
spray106720062spra_y
sprays115913642sprays
straw813321292straw_
straws98718672straws
strawy1210312822strawy
sural55931262sura_l
trawl84915872_trawl
appal95315223appa_l
appall10379743appall
astral66919283astra_l
aural54428963aura_l
awl67635303___awl
bawl95326063__bawl
becrawl1444583becrawl
boral75831703bora_l
brail75525553_brail
braw94829563_braw_
brawls115214333_brawls
brawly144312353_brawly
brawn106018563_brawn
braws106425193_braws
coral76033453cora_l
craal74117753_craal
craw97725263_craw_
crawls114712083_crawls
crawly144610763_crawly
craws105723123_craws
derail74218813derail
drail65020973_drail
draw85623013_draw_
drawls105511393_drawls
drawly134910723_drawly
drawn95614243_drawn
draws95119373_draws
dural64923893dura_l
espial839543espia_l
estral64716513estra_l
feral85424653fera_l
frail85220213_frail
goral65125753gora_l
graal64316503_graal
grail64622873_grail
growl96115823_growl
gyral94412783gyra_l
horal86328673hora_l
jural125120483jura_l
kraal94511823_kraal
loral55927823lora_l
moral75533433mora_l
mural75225103mura_l
narwal938943narwal
opal66923523op_a_l
oral47638123_ora_l
pail66141833_p_ail
pal56761673_p_a_l
pall65039343_p_all
parol74826273_parol
paw87651173_p_aw_
pawls105617663_p_awls
pawn94625303_p_awn
paws96038183_p_aws
peal68648103_pea_l
pearl75324463_pearl
pial65636703_pia_l
praam94815613_praam
prahu105013973_prahu
pram85733493_pra_m
prams96125513_prams
prang84820323_prang
prank115019453_prank
prao66229023_pra_o
praos74923563_praos
prase76128753_prase
prat65952043_pra_t
prate75135983_prate
prats76333393_prats
prau66529473_pra_u
praus74621753_praus
prawns11509023_prawns
pray96331533_pra_y
prays105022433_prays
prill74117943_prill
prow97030383_prow_
prowls115511083_prowls
prows106327013_prows
pshaw13447513pshaw_
pshaws14435703pshaws
rail46147763__rail
raw67252253__raw_
rawly115115833__rawly
raws75238213__raws
rural55821173rura_l
sabal75422483saba_l
sacral83414413sacra_l
sail45447163s__ail
sal36462883s__a_l
salal55425703sala_l
sall44544683s__all
saran53730303sara_n
sarans64224433sarans
sarape84817573sarape
saul45836523s__aul
saw68255353s__aw_
sawn75428163s__awn
saws75839483s__aws
scall74420373s_call
scowl1012012973s_cowl
scrag85916173scra_g
scrags95713803scrags
scram910621613scra_m
scrams105216623scrams
scrap97120403scra_p
scrape105917573scrape
scraps106017243scraps
scrawled1445903scrawled
scrawler1345883scrawler
scrawny15213933scrawny
screw109318533screw_
screws115513883screws
screwy14659453screwy
scroll8310163scroll
seal45654373s_ea_l
sepal77723003sepa_l
septal84513383septa_l
sera46141393sera__
serac75925203sera_c
seracs84418573seracs
serai56830163sera_i
serails73318363serails
serais64326133serais
serape84818413serape
seraph114011163seraph
serial64625853serial
serow86720443serow_
serows96016393serows
serval93913413serval
setal56430903seta_l
shall85024053s_hall
shaul85418103s_haul
shaw108132553s_haw_
shawls125411973s_hawls
shawm135316143s_hawm
shawn116417613s_hawn
shaws116226263s_haws
sheal84927703shea_l
shoal83920263shoa_l
shrank13359123shrank
shrew119720163shrew_
shrewd136810773shrewd
shrews129313913shrews
shrill94712303shrill
sial45938833s_ia_l
sisal54217733sisa_l
skoal93811453skoa_l
slaw77930713s_law_
slaws85222713s_laws
small74016263s_mall
snail57020203s_nail
snarl54921083s_narl
snaw78923073s_naw_
snaws86116363s_naws
soprani937403soprani
soprano937003soprano
sora45746913sora__
soras55041013sora_s
sorel56231443sor_el
sorrel6413543sorrel
spa55730813sp_a__
space95325673sp_ace
spacy125415623sp_acy
spade84423323sp_ade
spado83713703sp_ado
spae65034323sp_a_e
spaed85522273sp_aed
spaes76029973sp_aes
spahi10311143sp_ahi
spails84817823sp_ails
spait75631603sp_ait
spake114322743sp_ake
spale74929213sp_ale
spalls84217343sp_alls
spam85930043sp_a_m
spams94922193sp_ams
span65234663sp_a_n
spang84919733sp_ang
spank115919573sp_ank
spans74528733sp_ans
spar65433303sp_a_r
sparable121611973sparable
spare75135563sp_are
spared95427483spared
sparely123410663sparely
sparer84524963sparer
spares84834553spares
sparge94216043sparge
sparid94016933sparid
spark114920893sp_ark
sparkle133710203sparkle
sparkly16348123sparkly
sparks124616363sparks
sparky154511523sparky
sparry115111303sparry
spars75431543sp_ars
sparse84516343sparse
spas67036723sp_a_s
spasm94514173sp_asm
spat66548523sp_a_t
spate74731583sp_ate
spats75031383sp_ats
spawns11577923sp_awns
spay96631663sp_a_y
spays105520513sp_ays
spaz155626163sp_a_z
spazz155811133sp_azz
speak114618673spea_k
speaks125114583speaks
spean74620513spea_n
speans85417143speans
spear75821063spea_r
spears84019473spears
speel74420763sp_eel
speil75618643sp_eil
spell75020303sp_ell
spew95421873sp_ew_
spews105015923sp_ews
spheral1238423sphera_l
spiel74623913sp_iel
spill74821163sp_ill
spinal84915313spinal
spinel85317333spinel
spiracle1255803spiracle
spiraea9407983spiraea
spirally1348013spirally
spirals93212513spirals
spirant9814293spirant
spital83813873spital
splake1259783splake
splash1168823splash
splat76129343spla_t
splats84817303splats
splay105816043spla_y
splays114910873splays
spoil75818643sp_oil
spool75219043sp_ool
spraddle12194163spraddle
sprains93013593sprains
sprangs104610053sprangs
sprattle1054763sprattle
sprawlers1433893sprawlers
sprawlier1443293sprawlier
sprawling15175123sprawling
sprayed13398903sprayed
sprayer12369043sprayer
spread9312533spread
spreads1039763spreads
spree74830863spr_ee
sprees85620643sprees
sprent84522383sprent
sprier84119063sprier
sprig85617743spr_ig
sprigs94814773sprigs
spring94526013spring
sprint84526793sprint
sprit76736403spr_it
sprite84421773sprite
sprits85122533sprits
spritz174714413spritz
sprout8419403sprout
spruce103910873spruce
sprucy13356323sprucy
sprue74717633spr_ue
sprues84515763sprues
sprug85313893spr_ug
sprugs94010173sprugs
sprung94610033sprung
spry96819123spr__y
spryer11418533spryer
spryly1435513spryly
spurgall1143253spurgall
squall1537993squall
squaw17368983squaw_
squawk22385373squawk
squaws18438783squaws
stall54722353s_tall
staw78627693s_taw_
steal56125473stea_l
strafe95215973strafe
strain64919573strain
strait64025893strait
strake104017393strake
strand74514823strand
strang75718313strang
strap77925263stra_p
straps87721783straps
strass67117223strass
strata63616283strata
stratal72710603stratal
strath93216363strath
strati63518893strati
strawed114813613strawed
stray88525573stra_y
strays96417933strays
streel64214023streel
strew89220653strew_
strewn96710003strewn
strews96817093strews
stroll6311603stroll
strow88920573strow_
strown96812093strown
strows96718273strows
supra73614253supra__
sura45740293sura__
surah86823253sura_h
surahs94515543surahs
suras55336323sura_s
swail86217163s_wail
thrall93810293thrall
thraw1110515923thraw_
thrawn12769423thrawn
thraws129211103thraws
trail55126773_trail
trawls94412393_trawls
uprate83916543uprate
viral86419593vira_l
wawl105321943__wawl
yawl104918973__yawl

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163545.53020382.6
3Display Results3543540.1103218.2
 (SQL Overall)1786913545.78330899.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.