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

229 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
sweeten1026731(None) 
sweetens11255431sweetens
sweeter103212001sweeter
sheeted113813042sheeted
sheeter103814912sheeter
skeeter113410412skeeter
sleeken11326802sleeken
sleeted83113222sleeted
steepen9348652steepen
sweated113411542sweated
sweater103712722sweater
sweeney13387002sweeney
sweeper12329372sweeper
sweet85330522sweet__
sweetened1343252sweetened
sweetener1243402sweetener
sweetest1137172sweetest
sweetie10157872sweetie
sweeties11159722sweeties
sweeting123911312sweeting
sweetly1335592sweetly
sweets94214432sweet_s
swelter103711172swelter
sweven1235982sw_even
tweeted11336582tweeted
tweeter10288532tweeter
weeted103913792_weeted
beaten84617063_beaten
deepen9339193_deepen
eaten55323053__eaten
fleeted113310233fleeted
fleeter103210363fleeter
freemen1238463freemen
gleemen1035723gleemen
gleeted9379323gleeted
greaten83610643greaten
greeted93111383greeted
greeter82812673greeter
lenten6312883_lenten
meeter83616503_meeter
neaten64214543_neaten
pecten102711103_pecten
presweeten1552593presweeten
preteen939873preteen
quieten16258103quieten
sateen63815013sate_en
scented102811883scented
scepter1138363scepter
screen85216023scre_en
seamen84518563s_eamen
seated75131063s_eated
seater64534163s_eater
seeded84520463s_eeded
seeder74320773s_eeder
seedmen1037683seedmen
seeker103615363s_eeker
seeled73922093s_eeled
seemed95117613s_eemed
seemer84418043s_eemer
seen46943123s__e_en
seeped94317523s_eeped
seethe93712483s_eethe
seethed113410193s_eethed
seethes103613743s_eethes
seitan62613233s_eitan
semen75724103s__emen
sente56432883s_ente_
septet8921133s_eptet
sestet6826203s_estet
seton55223543s__eton
settee63721023s_ettee
setter64023723s_etter
seven84118313s__even
sewered112911243sewered
sextan13389643s_extan
sextet13916873s_extet
sexton133610793s_exton
shebeen1234553shebeen
sheen85023313s_he_en
sheened113511703sheened
sheeney13398933sheeney
sheepmen1544643sheepmen
sheered113515453sheered
sheerer103813843sheerer
sheet84836963sheet__
sheeters113111863sheeters
sheetfed1544143sheetfed
sheeting122712833sheeting
sheets93918503sheet_s
sheeve123412843sheeve_
sheeves133911953sheeves
sheitan1036573sheitan
shelter103214963shelter
shorten103511413shorten
shotten10288463shotten
shtetel1033943shtetel
sidemen1037943sidemen
sitten64113823s_itten
sixteen1434113sixteen
skeen94817403s_ke_en
skeet95429183skeet__
skeeters12298963skeeters
skeets104513253skeet_s
skeleton1244473skeleton
skelter113610003skelter
sleeked123510883sleeked
sleekens12274873sleekens
sleeker11339823sleeker
sleeper93211563sleeper
sleet55639133sleet__
sleetier837883sleetier
sleeting93114163sleeting
sleets64318873sleet_s
sleety94112653sleet_y
sleeve93411593sleeve_
sleeved11419913sleeved
sleeves103311343sleeves
smarten9348863smarten
smeeked14287223smeeked
smelted10399093smelted
smelter93311913smelter
smitten936693smitten
sneered83113973sneered
sneerer73512313sneerer
sneeze15318523sneeze_
sneezed17287793sneezed
sneezer16237963sneezer
sneezes16278503sneezes
soften9429493s_often
sokemen1337053sokemen
specter113111733specter
speeded113310423speeded
speeder103811073speeder
speeled103712453speeled
speered103614813speered
spelter94113703spelter
spleen8310263sple_en
steeked124010473steeked
steeled83513223steeled
steeped103412283steeped
steepens10277113steepens
steeper93812773steeper
steered83615253steered
steerer73113633steerer
steeve93710903steeve_
steeved113610133steeved
steeves103410903steeves
stetted82610403stetted
stouten7307333stouten
subteen938523subteen
svelte9319753svelte_
svelter10359673svelter
swagmen1334973swagmen
swatted114110693swatted
swatter104113323swatter
swearer10349953swearer
sweat85628403sweat__
sweaters113811063sweaters
sweatier1147033sweatier
sweating123213023sweating
sweats94814613sweat_s
sweaty123710053sweat_y
swede94413203sw_ede_
swedes102711893sw_edes
sweeneys14294023sweeneys
sweenies11148763sweenies
sweeny12358843swee_ny
sweep104715723sw_e_ep
sweepers13348163sweepers
sweepier1355493sweepier
sweeping14389143sweeping
sweeps114110513swee_ps
sweepy14447453swee_py
sweer84918573sw_e_er
sweeteners1343163sweeteners
sweetening14134133sweetening
sweetings13326183sweetings
sweetish1445373sweetish
sweetmeat1442823sweetmeat
sweetness1245683sweetness
sweetsop1341893sweetsop
swelled113211703swelled
sweller103012473sweller
swelters113110193swelters
sweltry1333413sweltry
swept105720603swept__
swerve1256293swerve_
swerved1455703swerved
swerver1365733swerver
swerves1377533swerves
swevens1334613sw_evens
swidden1234233swidden
swifter13318053swifter
swollen1034263swollen
swotted11398713swotted
swotter10399473swotter
teeter65420313_teeter
tween84413743tw_e_en
tweener10306833tweener
tweet84823983tweet__
tweeters11287143tweeters
tweeting12267033tweeting
tweets94210103tweet_s
tweeze18265473tweeze_
tweezed20274993tweezed
tweezer19305763tweezer
tweezes19345703tweezes
uneaten7412543uneaten
weaken13349603_weaken
weeded113914873_weeded
weeder103315513_weeder
weekend1533393_weekend
ween75835463_w_e_en
weened104013733_weened
weeper114313303_weeper
weet75254153_weet__
weeting113816053_weeting
weets85427723_weet_s
weever123811443_weever
weewee12310083_weewee
welted103715823_welted
welter93417383_welter
wester94222893_wester
western102911103_western
wetted103717023_wetted
wetter93919443_wetter
wheaten1336403wheaten
wheen115016053_whe_en
whiten124111923_whiten

Search took 7 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.420425454.8
2DLD Change Limit1340272295.89322743.4
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.38927968.5
 
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.