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

522 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
swotter1039946(None) 
slotter73314441slotter
spotter94514871spotter
swatter104113321swatter
swotted11398701swotted
swotters11448481swotters
blotter94612852blotter
cotter84926672_cotter
dotter74419342_dotter
hotter94720072_hotter
jotter134315632_jotter
knotter11317642knotter
lotter64025602_lotter
otter54423972__otter
plotter94113662plotter
potter83926982_potter
rotter64325462_rotter
scatter93815172scatter
scooter93312862scooter
scoter83815472sco_ter
scouter93313322scouter
scutter93512172scutter
setter64023722s_etter
shatter103615692shatter
shooter103013982shooter
shorter103515492shorter
shotted113912392shotted
shotten10288452shotten
shouter103213072shouter
shutter103712132shutter
sitter63323382s_itter
skitter113810392skitter
slitter73615872slitter
slotted84613872slotted
slotters84012402slotters
smatter93613332smatter
smother123510202smother
snorter74412662snorter
snottier8217372snottier
softer94015312s_ofter
soother104215032soother
sootier73916602sootier
sorter64425082s_orter
sotted74121392s_otted
souter64225922s_outer
spatter94016522spatter
spitter94015182spitter
sporter93616552sporter
spotted103713132spotted
spotters104313382spotters
spottier10207302spottier
spouter94213222spouter
sputter94014052sputter
stotted83511412stotted
stouter74012052stouter
stutter72911462stutter
swather134213602swather
swatted114110692swatted
swatters113911792swatters
sweater103712722sweater
sweeter103212002sweeter
swelter103711172swelter
swifter13318052swifter
swither133710992swither
swobber14336542swobber
swooner10358672swooner
swooper12389172swooper
totter65021462_totter
trotter73312252trotter
twitter10278092twitter
watter93221982_watter
wetter93919442_wetter
wotted104115712_wotted
abetter958323abetter
aborter939923aborter
abutter957513abutter
adopter1036753adopter
allotter866473allotter
another10289153another
assorter866663assorter
atwitter1143673atwitter
awaiter1057443awaiter
batter84928873_batter
better84723703_better
bitter84622673_bitter
blatter94415653blatter
bloater94013423bloater
blotted103911833blotted
blotters104110983blotters
blottier10336413blottier
boater84622093_boater
bolter83920753_bolter
booster94314553booster
bother115218063_bother
bottler94211883_bottler
brother123311333brother
butter84724233_butter
chatter124416643chatter
chitter124112963chitter
clatter94014973clatter
clotted104011823clotted
clouter93511693clouter
clutter94211663clutter
coater84329573_coater
colter84625093_colter
cooter85128613_cooter
copter109822013_copter
coster84331293_coster
cottar84613813_cottar
cotters94323443_cotters
cottier93814173_cottier
couter84930223_couter
critter94113033critter
crofter12299573crofter
cutter84521003_cutter
diopter1038473diopter
doter65428623_do_ter
dotier73917033_dotier
dotted84717523_dotted
dottel73610893_dottel
dotters83715973_dotters
dottier83910923_dottier
emitter93211083emitter
emoter85415193emo_ter
fatter94523213_fatter
fetter94120383_fetter
fitter94120033_fitter
flatter103815963flatter
flitter103413903flitter
floater104413353floater
flouter104311343flouter
flutter104012093flutter
footer94320773_footer
footier104115113footier
footler104011873footler
foster94322223_foster
fretter103412753fretter
fritter103912773fritter
fronter103611583fronter
frother133110153frother
frotteur1142503frotteur
garotter965943garotter
getter74117613_getter
glitter84211803glitter
gloater83711013gloater
goiter74116203_goiter
gotten73410113_gotten
gritter83913353gritter
grottier9316673grottier
grouter84412523grouter
gutter73817713_gutter
hatter94724873_hatter
hitter94419863_hitter
hooter94123923_hooter
hootier104915343hootier
hotted104319933_hotted
jitter133314993_jitter
jolter133513093_jolter
jotted143615173_jotted
jotters143413803_jotters
knitter11348133knitter
knotted12357223knotted
knotters12276153knotters
knottier12203983knottier
latter65027893_latter
letter63722583_letter
litter64324853_litter
lofter94614723_lofter
loiter64619173_loiter
looter64222323_looter
lotte54923853_lotte_
lotted74222403_lotted
lotters73921063_lotters
lottery10389833_lottery
lottes65322753_lottes
matter84325343_matter
molter84119423_molter
mooter83921093_mooter
mother113718643_mother
motte75526973_motte_
mottes85523693_mottes
mottler94410343_mottler
mutter84418883_mutter
natter64420743_natter
netter63722023_netter
noter55025643_no_ter
nother93815963_nother
nutter63918053_nutter
oater55433733__oater
ofter84116873__ofter
omitter9298503omitter
other84219103__other
ottar54313993__ottar
otters64021513__otters
outer55633303__outer
oxter123414093__oxter
patter84628263_patter
petter83924773_petter
phatter123810203phatter
platter93917413platter
plotted104612373plotted
plotters104011553plotters
plottier10327263plottier
poofter1237163poofter
porter84224413_porter
poster84129173_poster
pother113818853_pother
potted94624013_potted
potters94024343_potters
pottery123011073_pottery
pottier93516493_pottier
potzer174411203_potzer
pouter83923983_pouter
powter114116033_powter
putter83921443_putter
quitter162910753quitter
quoter153510093quo_ter
ratter64326313_ratter
reutter71010093reutter
rioter64817283rio_ter
ritter63822423_ritter
rooster74415173rooster
rooter64926033_rooter
rootier74915393rootier
roster64329083_roster
rotte54625933_rotte_
rotted74524433_rotted
rotten64115433_rotten
rotters74421393_rotters
rottes64524833_rottes
router65025843_router
salter64325083s_alter
saltier74318633saltier
saluter73512453saluter
saunter72913453saunter
scanter94215183scanter
scatted103512773scatted
scatters103612753scatters
scattier10267583scattier
scepter1138353scepter
scoffer15317023scoffer
scolder103210333scolder
scooper113812033scooper
scooted103612273scooted
scooters103511023scooters
scorer84818253sco_rer
scorner9259763scorner
scoters93313803sco_ters
scottie937453scottie
scotties1039743scotties
scourer93910433scourer
scouted104112033scouted
scouters103411323scouters
scouther1356943scouther
scowder13286853scowder
scowler12248173scowler
scutters103311023scutters
seater64534153s_eater
sedater83713623sedater
seltzer1635203seltzer
settee63721023s_ettee
setters73822063s_etters
settler73410653settler
shatters113313903shatters
sheeter103814903sheeter
shelter103214953shelter
shifter132911073shifter
shitted114212043shitted
shittier1137303shittier
shoaler102610073shoaler
shocker163411423shocker
shoer84722153sho__er
shooters112811573shooters
shopper143312623shopper
shorted113614393shorted
shorten103511403shorten
shote85526093sho_te_
shotes95321903sho_tes
shott85332183shott__
shotts93614693shott_s
shouted113911543shouted
shouters113510613shouters
shover124515983sho_ver
shower124315103sho_wer
showier1339093showier
shunter103611723shunter
shutters113611343shutters
shuttler1164893shuttler
shyster13116553shyster
sifter94516233s_ifter
sighter113412113sighter
siltier73413863siltier
sinter63625923s_inter
sister64421583s_ister
sitten64113823s_itten
sitters74221553s_itters
skater105015483s_kater
skeeter113410413skeeter
skelter113610003skelter
skirter11338483skirter
skitters12349553skitters
skittery15315103skittery
slater64429183s_later
slather103816073slather
slatier74016813slatier
slatted84015183slatted
slattern837093slattern
slither104112983slither
slitted83513313slitted
slitters84014133slitters
slittier837003slittier
slobber11388903slobber
slogger94310483slogger
sloper84615913slo_per
slower94016153slo_wer
sluttier836453sluttier
smarter94113133smarter
smatters104011713smatters
smelter93311913smelter
smiter83616413s_miter
smitten936693smitten
smoker124311693smo_ker
smokier1356703smokier
smolder10327753smolder
smoother13196663smoother
smote75820273smo_te_
smothers13349933smothers
smothery16296063smothery
smutted1037463smutted
smuttier1035213smuttier
snifter10349623snifter
snooker113910303snooker
snooper93511533snooper
snooted84213273snooted
snootier8278373snootier
snoozer16409183snoozer
snorer64316763sno_rer
snorted83813493snorted
snorters83410583snorters
snotty9489193snott_y
snouted84311343snouted
snoutier8206973snoutier
snowier1038793snowier
soaker105717533s_oaker
soaper84517873s_oaper
soarer64522243s_oarer
sobber104016583s_obber
sober74822403s_o_ber
soccer1038543s_occer
soever94412093s_oever
soften9429493s_often
solder73921343s_older
solver94016703s_olver
somber103713993s_omber
sonder73623523s_onder
sooner64220463s_ooner
sooted73922583s_ooted
soothe94214843soothe_
soothed113712733soothed
soothers113913433soothers
soothes103917103soothes
sorer56236573s_o_rer
sorner64720383s_orner
sorted74523713s_orted
sorters74221123s_orters
sourer63620213s_ourer
souters74422603s_outers
souther104116303souther
sower85229313s_o_wer
spatted104014143spatted
spatters103914703spatters
specter113111733specter
spelter94113703spelter
spitted103912703spitted
spitters104113383spitters
splatter10348883splatter
splitter10348443splitter
splutter10357443splutter
spoiler93310683spoiler
sponger1038523sponger
spoofer12368723spoofer
spooler93711383spooler
sported104015433sported
sporters103714063sporters
sportier102010053sportier
spotty11448573spott_y
spouted103412263spouted
spouters104011163spouters
spurter94013003spurter
sputters104012873sputters
sputtery13366473sputtery
squatter1735913squatter
starter73817883starter
stater64427563s_tater
steer55423863s__teer
stetted82610403stetted
stinter73614513stinter
stocker133713083stocker
stoker104417623sto_ker
stomper114111233stomper
stoner65823203sto_ner
stonier72013793stonier
stooker113811733stooker
stooper93813193stooper
stoper84320103sto_per
stopper113012603stopper
storer64721673sto_rer
stott56929783stott__
stotts64612853stott_s
stouten7307333stouten
stover94115643sto_ver
strutter846503strutter
stutters83210473stutters
subtler92910843subtler
suiter64121813s_uiter
sumpter1138873sumpter
sutler63718393s_utler
suttee63721543s_uttee
svelter10359673svelter
swabber14297963swabber
swager104013613sw_ager
swagger12389333swagger
swamper14349313swamper
swanker14369483swanker
swapper14359703swapper
swarmer1247803swarmer
swasher134011513swasher
swathe125514113swathe_
swathed144611933swathed
swathers144512083swathers
swathes134115513swathes
swayer125210973sw_ayer
swearer10349953swearer
sweated113411543sweated
sweaters113811063sweaters
sweatier1147033sweatier
sweeper12329373sweeper
sweer84918573sw__eer
sweeten10267313sweeten
sweller103012463sweller
swelters113110193swelters
swerver1365733swerver
swifters14277483swifters
swigger12338453swigger
swiller103211663swiller
swimmer14297653swimmer
swinger113812563swinger
swisher13369523swisher
switcher16177683switcher
swithe124010683swithe_
swithers144310533swithers
swobbed15335443swobbed
swobbers15355593swobbers
swollen1034263swollen
swooned11368593swooned
swooners11336863swooners
swoonier11185133swoonier
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
swopped15437673swopped
swore84920813swo_re_
swot75134653swo_t__
swots85518423swo_t_s
swotting12268473swotting
swouned11366663swouned
tatter64024573_tatter
tetter64322453_tetter
titter63421163_titter
tooter64420803_tooter
tootler73511123tootler
toter55932133_to_ter
tother94117143_tother
totted74319953_totted
totters74618733_totters
tottery10388483_tottery
touter63821033_touter
trotted83711283trotted
trotters83310243trotters
tweeter10288533tweeter
twister10308953twister
twitted11326633twitted
twitters11296773twitters
twittery14303893twittery
twofer1234353two_fer
utter54218763__utter
vetter93417643_vetter
voter85121053_vo_ter
wafter124114613_wafter
waiter94321253_waiter
wanter94423053_wanter
waster95228943_waster
water84733313_w_ater
welter93417383_welter
wester94222893_wester
wether123315393_wether
wetted103717023_wetted
wetters103817753_wetters
whetter13348803whetter
whiter124316393_whiter
whitter139110893whitter
winter94222803_winter
wither124321353_wither
witted104216813_witted
wittier103910823_wittier
wolfer12429983_wolfer
wolver12419713_wolver
wonder103617813_wonder
wonner95114443_wonner
wonted103213283_wonted
wooer84316693_wo_oer
woofer124411363_woofer
wooler93615873_wooler
worker134715113_worker
wormer114514913_wormer
worser95117523_worser
wowser125110203_wowser
writer94416513_writer
wuther124511613_wuther
yatter94116213_yatter
zootier163611173zootier
zoster153715853_zoster

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340275228.31016128.4
3Display Results5225220.1902747.4
 (SQL Overall)1786915228.66020634.1
 
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.