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

520 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
swelter10371117(None) 
shelter103214951shelter
skelter113610001skelter
smelter93311911smelter
spelter94113701spelter
svelter10359671svelter
sweater103712721sweater
sweeter103212001sweeter
sweller103012461sweller
swelters113110191swelters
welter93417381_welter
belter84720962_belter
dweller11297272dweller
kelter103214372_kelter
melter83520112_melter
pelter83321622_pelter
salter64325082s_alter
scepter1138352scepter
seater64534152s_eater
seller63824592s_eller
seltzer1635202s_eltzer
setter64023722s_etter
sheeter103814902sheeter
sheller103515882sheller
shelters113412802shelters
shelver134211062shelver
skeeter113410412skeeter
skelters12349372skelters
smeller94212782smeller
smelted10399092smelted
smelters103310512smelters
smeltery13274962smeltery
sneller73512842sneller
specter113111732specter
speller95415142speller
spelters103912242spelters
svelte9319752svelte_
swatter104113322swatter
swearer10349952swearer
sweated113411542sweated
sweaters113811052sweaters
sweatier1147032sweatier
sweeper12329372sweeper
sweer84918572swe__er
sweeten10267312sweeten
swelled113211692swelled
sweltered1344452sweltered
sweltrier1242992sweltrier
sweltry1333412sweltry
swerver1365732swerver
swifter13318052swifter
swiller103211652swiller
swotter10399462swotter
tweeter10288532tweeter
welder102914412_welder
welted103715822_welted
welters103516062_welters
wester94222892_wester
wetter93919442_wetter
abetter958323abetter
adepter1036113adepter
alerter72111513alerter
alter54828503__alter
assenter867703assenter
asserter877563asserter
atelier7311623atelier
averter102410553averter
awaiter1057443awaiter
aweather1434263aweather
beater84729393_beater
beetler938033beetler
belier84423563_belier
belted94020633_belted
belters93819413_belters
better84723703_better
bleater94515303bleater
bolter83920753_bolter
center84421413_center
cheater124816953cheater
colter84625093_colter
coulter94115593coulter
defter104215923_defter
delver104913493_delver
deter65028043_de_ter
dewater112912423dewater
dexter143810893_dexter
diester83013683diester
dieter73516773die_ter
dueler74213683duel_er
dueller8329833dueller
dwelled12337593dwelled
dwellers12356083dwellers
dwelt94316523dwelt__
eater54639843__eater
eelier64216463_eelier
elater64724203__elater
elder64020023__elder
elver85216243__elver
enter54726383__enter
erecter93113393erecter
ester54727713__ester
exalter1437563exalter
falter94519053_falter
feater95224053_feater
feeler93215173feel_er
feller94419553_feller
felted103714653_felted
fester94723513_fester
fetter94120383_fetter
fielder11217413fielder
filter94517633_filter
fleeter103210363fleeter
fretter103412753fretter
fueler94313933fuel_er
fueller10279963fueller
gelder84613713_gelder
getter74117613_getter
greater84416493greater
greeter82812673greeter
halter94420883_halter
heater94828303_heater
heeler93917313heel_er
hefter124313923_hefter
heller93322513_heller
helper114313093_helper
jester134319153_jester
jeweler1735053jewel_er
jeweller1844123jeweller
jilter133512513_jilter
jolter133513093_jolter
keester11319913keester
kelters113813753_kelters
kiester11329973kiester
kilter103714343_kilter
lefter93613433_lefter
letter63722583_letter
meeter83616503_meeter
melder93915813_melder
melted94219063_melted
melters93918313_melters
meter75130323_me_ter
mewler113510233mewl_er
milter84921233_milter
molter84119423_molter
moulter93812423moulter
neater64424313_neater
nester64124183_nester
netter63722023_netter
neuter63713793_neuter
palter84423263_palter
peeler83517383peel_er
pelted94617753_pelted
pelters93720313_pelters
perter84422283_perter
pester84827593_pester
peter74427593_pe_ter
petter83924773_petter
pewter114013673_pewter
philter12108213philter
pleater93916333pleater
poulter93712013poulter
prealter1048863prealter
prester93519623prester
psalter9247813psalter
queller16289293queller
quester161410023quester
quilter16279803quilter
realter73716313realter
reeler63822573reel_er
reenter73217793reenter
relater73723143_relater
relier65826183_relier
renter64527413_renter
rester63832433_rester
sailer63526103sail_er
sallier73320423sallier
salted74121203s_alted
saltern74010653s_altern
salters73622253s_alters
saltier74318633s_altier
saluter73512453saluter
salver94617753s_alver
saunter72913453saunter
scaler84321603scal_er
scalier94316913scalier
scalper113912923scalper
scanter94215183scanter
scatter93815173scatter
scented102811883scented
scepters1237783scepters
sceptre1135043sceptre
scolder103210333scolder
scooter93312863scooter
scoter83815473s_coter
scouter93313323scouter
sculker13318323sculker
sculler99812153sculler
scutter93512173scutter
sealer63928963s_ealer
seamer84223613s_eamer
searer65432023s_earer
seated75131053s_eated
seaters74028933s_eaters
sector83415923s_ector
sedater83713623sedater
seder64826753s_e_der
seeder74320773s_eeder
seedier83513633seedier
seeker103615363s_eeker
seeled73922093seel_ed
seemer84418043s_eemer
seemlier1035193seemlier
seepier92912013seepier
seer45547043s_e__er
seiner64622483s_einer
seiser65318343s_eiser
seizer154114573s_eizer
selfed10310913s_elfed
selle54428313s_elle_
sellers73721303s_ellers
selles64426983s_elles
seltzers1735063s_eltzers
selves94119613s_elves
semester1038903semester
sender73824413s_ender
sente56432873s_ente_
septet8921133s_eptet
serer55935503s_e_rer
serger73819733s_erger
server94917713s_erver
sestet6826203s_estet
settee63721023s_ettee
setters73822063s_etters
settler73410653s_ettler
sever85426053s_e_ver
sewer84426213s_e_wer
sexier13310683s_exier
sextet13916873s_extet
shalier103116423shalier
shatter103615693shatter
shearer104414683shearer
sheather1458213sheather
shedder12339323shedder
sheer84726893she__er
sheerer103813843sheerer
sheeted113813033sheeted
sheeters113111853sheeters
shelled113815083shelled
shellers112812563shellers
shellier1138393shellier
shelta93111783shelt_a
sheltas10279663sheltas
sheltered1335573sheltered
shelterer1245033shelterer
sheltie10109893sheltie
shelties111111373shelties
shelty124011543shelt_y
shelve124012763shelve_
shelved14379933shelved
shelvers14388813shelvers
shelves134112093shelves
shelvier1464913shelvier
shewer124515103she_wer
shielder1235183shielder
shifter132911073shifter
shooter103013973shooter
shorter103515493shorter
shouter103213073shouter
shunter103611723shunter
shutter103712133shutter
shyster13116553shyster
sidler74716963sidl_er
sifter94516233s_ifter
sighter113412103sighter
silenter838873silenter
siller64026053s_iller
sillier74017583sillier
silted74020013s_ilted
siltier73413863s_iltier
silver93815813s_ilver
sinter63625923s_inter
sister64421583s_ister
sitter63323383s_itter
skater105015483s_kater
skeeters12298963skeeters
skelped1435203skelped
skeltered1443873skeltered
skewer13519603ske_wer
skirter11338483skirter
skitter113810393skitter
skulker10325683skulker
slater64429183s_later
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
sleeted83113223sleeted
sleetier837883sleetier
slender83413593slender
slier54827243s__lier
slitter73615873slitter
slotter73314443slotter
slyer85515123s__lyer
smaller93410333smaller
smarter94113133smarter
smatter93613333smatter
smearer94110403smearer
smelled103511853smelled
smellers10329753smellers
smellier1036793smellier
smelt74726783smelt__
smelts85412773smelt_s
smiler83916683smil_er
smiter83616413s_miter
smolder10327753smolder
sneaker112910453sneaker
sneer54919953sne__er
sneerer73512313sneerer
sneezer16237963sneezer
snelled83313043snelled
snifter10349623snifter
snorter74412653snorter
soever94412093soe_ver
softer94015313s_ofter
solder73921343s_older
solver94016703s_olver
sorter64425083s_orter
souter64225923s_outer
spaller92713473spaller
spatter94016523spatter
speaker133311213speaker
spearer93913663spearer
specters122811063specters
spectre11297773spectre
speeder103811073speeder
speer74623903spe__er
spelled103714733spelled
spellers102812743spellers
spelt75430193spelt__
spelts84614643spelt_s
speltz174010113spelt_z
speltzes1943993speltzes
spencer113610973spencer
spender103713693spender
spewer115112143spe_wer
spieler93111233spiel_er
spiller92914323spiller
spitter94015183spitter
sporter93616553sporter
spotter94514873spotter
spouter94213223spouter
spurter94013003spurter
sputter94014053sputter
staler64025823stal_er
stalker113912253stalker
starter73817873starter
stater64427553s_tater
stealer72913973stealer
steamer93313093steamer
steelier839183steelier
steeper93812773steeper
steer55423863ste__er
steerer73113633steerer
stelae63716483stelae_
stelar64013863stel_ar
stele55026843stel_e_
steles63725663stel_es
stellar72610413stellar
stemmer113210183stemmer
stentor739373stentor
stepper113010853stepper
sterner7411913sterner
stertor7310083stertor
stetted82610403stetted
stiller73414283stiller
stilted83511473stilted
stinter73614513stinter
stouter74012053stouter
stutter72911463stutter
styler94013303styl_er
subtler92910843subtler
suiter64121813s_uiter
sulker104015923s_ulker
sumpter1138873sumpter
surlier72915443surlier
sutler63718393sutl_er
sveltely1442843sveltely
sveltest1135873sveltest
swabber14297963swabber
swager104013613sw_ager
swagger12389333swagger
swale85221593swal_e_
swales93920763swal_es
swamper14349313swamper
swanker14369483swanker
swapper14359703swapper
swarmer1247803swarmer
swasher134011503swasher
swather134213593swather
swatted114110693swatted
swatters113911793swatters
swayer125210973sw_ayer
swear85316853swe__ar
swearers11328583swearers
sweat85628403sweat__
sweats94814613sweat_s
sweaty123710053sweat_y
swede94413203swe_de_
swedes102711893swe_des
sweeney13387003sweeney
sweep104715723swe__ep
sweepers13348163sweepers
sweepier1355493sweepier
sweet85330523swe__et
sweetener1243403sweetener
sweetens11255433sweetens
sweetest1137173sweetest
sweetie10157863sweetie
sweeties11159723sweeties
sweetly1335593sweetly
sweets94214433sweet_s
swell84815983swel__l
swellest1137663swellest
swells93913983swel_ls
sweltering1445233sweltering
swept105720603swept__
swerve1256293swerve_
swerved1455703swerved
swervers1455213swervers
swerves1377533swerves
sweven1235983swe_ven
swifters14277483swifters
swigger12338453swigger
swilled113611833swilled
swillers11299103swillers
swimmer14297653swimmer
swinger113812563swinger
swirlier1135213swirlier
swisher13369523swisher
swither133710993swither
swobber14336543swobber
swollen1034263swollen
swooner10358673swooner
swooper12389173swooper
swotted11398703swotted
swotters11448473swotters
teeter65420313_teeter
telfer9379893_telfer
teller63519813_teller
tenter64623933_tenter
tester64227153_tester
tetter64322453_tetter
theater104014253theater
tilter63417693_tilter
treater74219833treater
tweener10306833tweener
tweeted11336583tweeted
tweeters11287143tweeters
tweezer19305763tweezer
twelve1234163twelve_
twelves1334303twelves
twister10308953twister
twitter10278093twitter
ureter6313203ure_ter
vaulter10257713vaulter
venter94218723_venter
vetter93417643_vetter
wafter124114613_wafter
waiter94321253_waiter
waler84229263_wal_er
walker133913993_walker
waltzer1934383_waltzer
wanter94423053_wanter
waster95228943_waster
water84733313_w_ater
watter93221983_watter
weaker134015443_weaker
weaner93816773_weaner
wearer94319403_wearer
weather133513223_weather
weaver123916613_weaver
weber10313523_we_ber
webster1236093_webster
wedder113612293_wedder
weeder103315513_weeder
weeper114313303_weeper
weer75535093_we__er
weeted103913793_weeted
weever123811443_weever
weiner94214133_weiner
welcher15319393_welcher
welded114013383_welded
welders113313413_welders
weldor10317653_weldor
welled103820213_welled
welsher13377443_welsher
welt75547863_welt__
weltered12238433_weltered
welts85225193_welt_s
western102911093_western
westers105221963_westers
wether123315393_wether
wetted103717023_wetted
wetters103817753_wetters
whetter13348803whetter
whiter124316393_whiter
wielder11197673wielder
wilder103616473_wilder
wilier93217073_wilier
willer94021063_willer
wilted103915713_wilted
winter94222803_winter
wolfer12429983_wolfer
wolver12419713_wolver
wrester102812413wrester
writer94416513_writer
yeller94214513_yeller
yelper11458783_yelper
yester93417983_yester
yielder11175113yielder
zester153617793_zester

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.1561145455.1
2DLD Change Limit1340275207.19018640.8
3Display Results5205200.1703058.8
 (SQL Overall)1786915207.51623774.7
 
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.