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

311 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
shotten1028844(None) 
shorten103511401shorten
shotted113912381shotted
chorten122811302chorten
gotten73410112_gotten
hotted104319932_hotted
hotter94720072_hotter
rotten64115432_rotten
shatter103615692shatter
shitted114212042shitted
shodden12265752shodden
shooter103013972shooter
shopmen14277192shopmen
shorted113614392shorted
shortens11288982shortens
shorter103515492shorter
shote85526082sho_te_
shotes95321892sho_tes
shotgun1142982shotgun
shott85332172shott__
shotting123012362shotting
shotts93614682shott_s
shouted113911542shouted
shouter103213072shouter
showmen15227162showmen
shutter103712132shutter
sitten64113822s_itten
slotted84613872slotted
slotter73314442slotter
smitten936692smitten
soften9429492s_often
sotted74121392s_otted
spotted103713132spotted
spotter94514872spotter
stotted83511412stotted
stouten7307332stouten
swotted11398702swotted
swotter10399462swotter
batten85217123_batten
begotten1143243begotten
bitten84715123_bitten
blotted103911833blotted
blotter94612853blotter
chasten124312403chasten
chatted133411893chatted
chattel12388893chattel
chatter124416643chatter
chitter124112963chitter
chortens13308793chortens
chosen116014133cho_sen
chott103923923chott__
chotts113610983chott_s
clotted104011823clotted
cotter84926673_cotter
cotton8312993_cotton
dotted84717523_dotted
dottel73610893_dottel
dotter74419343_dotter
fatten94314903_fatten
flatten10429653flatten
footmen1246583footmen
ghosted1236273ghosted
grutten885283grutten
hapten115312983_hapten
hasten95718563_hasten
hatted104921513_hatted
hatter94724873_hatter
hitmen11239193_hitmen
hitter94419863_hitter
hodden113811453_hodden
hoiden103612333_hoiden
holden104113953_holden
holpen11299413_holpen
hooted104422653_hooted
hooter94123923_hooter
hosen85623883_ho_sen
hosted105020343_hosted
hostel93914153_hostel
hotbed123310673_hotbed
hotel85520743_ho_tel
hottest10411383_hottest
hottie92514363_hottie
hotties103016953_hotties
hotting113116513_hotting
hoyden13328933_hoyden
hutted104616333_hutted
jotted143615173_jotted
jotter134315633_jotter
kitten104611483_kitten
knotted12357223knotted
knotter11317643knotter
latten65018203_latten
litten64014873_litten
lotte54923853_lotte_
lotted74222403_lotted
lotter64025603_lotter
lottes65322753_lottes
mitten83914093_mitten
molten83311813_molten
motte75526973_motte_
mottes85523693_mottes
oaten55222403__oaten
often84611413__often
otter54423973__otter
patten84418193_patten
phatter123810203phatter
photoed1338903photoed
photon1111514823pho_ton
plotted104612373plotted
plotter94113663plotter
poteen83514263_poteen
potmen102713093_potmen
potted94624013_potted
potteen9319673_potteen
potter83926983_potter
ratten64217383_ratten
rotte54625933_rotte_
rotted74524433_rotted
rotter64325463_rotter
rottes64524833_rottes
sateen63815013s_ateen
scatted103512773scatted
scatter93815173scatter
scooted103612273scooted
scooter93312863scooter
scoter83815473sco_ter
scottie937443scottie
scotties1039733scotties
scouted104112033scouted
scouter93313323scouter
scutter93512173scutter
settee63721023s_ettee
setter64023723s_etter
shafted14288803shafted
shaitan1036883shaitan
shaken134113613sh_aken
shantey134210033shantey
shapen114414653sh_apen
sharpen12389723sharpen
shatters113313903shatters
shaven124213303sh_aven
shebeen1234553shebeen
sheen85023313sh__een
sheeted113813033sheeted
sheeter103814903sheeter
sheitan1036563sheitan
shelter103214953shelter
shifted14359973shifted
shifter132911073shifter
shipmen14317283shipmen
shippen14298863shippen
shittah1385133shittah
shittier1137303shittier
shittim1245103shittim
shitting123212653shitting
shitty124110053shitt_y
shoaled113810963shoaled
shoaler102610073shoaler
shoat85633943shoat__
shoats94117073shoat_s
shocked174611803shocked
shocker163411423shocker
shoe75933433sho__e_
shoed95723003sho__ed
shoer84722153sho__er
shoes85429653sho__es
shoetree1146563shoetree
shogged13397953shogged
shogun1045703sho_gun
shone83725973sho_ne_
shooed103916073sho_oed
shooled115212653shooled
shoon84022003sho__on
shoot84235893shoot__
shooters112811553shooters
shooting122812843shooting
shoots94619343shoot_s
shopman14247253shopman
shoppe133110313shoppe_
shopped153512203shopped
shopper143312623shopper
shoppes143411383shoppes
shoran94016033sho_ran
shore85432643sho_re_
shored105723643sho_red
shores94830403sho_res
shorn85722173sho__rn
short85040523short__
shortened1345663shortened
shortener1245773shortener
shortest11310773shortest
shortia1048173shortia
shortie10411323shortie
shorties11414573shorties
shorting122514793shorting
shortly13387563shortly
shorts95321733short_s
shorty124313193short_y
shot76150243sho_t__
shotguns1242303shotguns
shots84730833sho_t_s
shout85433163shout__
shouters113510593shouters
shouting122711783shouting
shouts94017713shout_s
shove114421033sho_ve_
shoved134214273sho_ved
shovel124611313sho_vel
shover124515983sho_ver
shoves124919413sho_ves
showed135016963sho_wed
shower124315103sho_wer
showier1339093showier
showman15257283showman
shown115216473sho__wn
shriven13379653shriven
shtetel1033933shtetel
shtetl936433sh_tetl
shunted11339773shunted
shunter103611723shunter
shute84520343sh_ute_
shuted103913163sh_uted
shutes93518213sh_utes
shutters113611333shutters
shutting12309683shutting
shuttle1046093shuttle
shuttled1234663shuttled
shuttler1164893shuttler
shuttles1136543shuttles
shyster13116553shyster
sitter63323383s_itter
sixteen1434113sixteen
skitter113810393skitter
slatted84015183slatted
slattern837093slattern
slitted83513313slitted
slitter73615873slitter
slotters84012393slotters
slotting92612603slotting
sloven9389633slo_ven
smarten9348863smarten
smatter93613333smatter
smoothen13204953smoothen
smote75820273smo_te_
smother123510203smother
smutted1037463smutted
snooted84213273snooted
snorted83813493snorted
snorter74412653snorter
snottier8217373snottier
snotty9489193snott_y
snouted84311343snouted
snowmen12246153snowmen
socmen1039193s_ocmen
sodden84011513s_odden
softens10347623s_oftens
softer94015313s_ofter
sooted73922583s_ooted
soothe94214843soothe_
soothed113712733soothed
soother104215033soother
soothes103917103soothes
sootier73916603sootier
sorted74523713s_orted
sorter64425083s_orter
souter64225923s_outer
spatted104014143spatted
spatter94016523spatter
spitted103912703spitted
spitter94015183spitter
spoken124610003spo_ken
sported104015433sported
sporter93616553sporter
spotters104313373spotters
spottier10207303spottier
spotting112812083spotting
spotty11448573spott_y
spouted103412263spouted
spouter94213223spouter
sputter94014053sputter
stetted82610403stetted
stolen64315063sto_len
stollen747573stollen
stotin63215043sto_tin
stott56929783stott__
stotting92811153stotting
stotts64612853stott_s
stoutens8255273stoutens
stouter74012053stouter
stutter72911463stutter
subteen938523subteen
suttee63721543s_uttee
swatted114110693swatted
swatter104113323swatter
sweeten10267313sweeten
swollen1034263swollen
swotters11448473swotters
swotting12268473swotting
torten65314353_torten
totted74319953_totted
totter65021463_totter
trotted83711283trotted
trotter73312253trotter
ungotten944533ungotten
wheaten1336403wheaten
whetted14256693whetted
whetter13348803whetter
whiten124111923wh_iten
whitter139110893whitter
wotted104115713_wotted
written10336343written

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.1561145455.1
2DLD Change Limit1340273118.04616657.6
3Display Results3113110.1102827.3
 (SQL Overall)1786913118.31221498.0
 
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.