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

176 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
weekend153339(None) 
weekends1642731weekends
geeked124510162geeke_d
keeked104810122keeke_d
peeked134314582peeke_d
reeked113717642reeke_d
weaken13349602weaken_
weakened1634822weakened
weakens14367062weakens
weeded113914872weede_d
weekended1842172weekended
weekender1742462weekender
weened104013732weene_d
weeted103913792weete_d
weeweed1435192weeweed
beaked135919493beake_d
becked155417763becke_d
beefed123510873beefe_d
beeped115313453beepe_d
bookend14396643bookend
cheeked17399663cheeke_d
cleeked14357733cleeke_d
decked145217623decke_d
deeded94615543deede_d
deemed104713063deeme_d
deepen9339193deepen_
deepened1235663deepened
deepens10307813deepens
defend113910493_defend
deked115718533_deke_d
depend103510923_depend
descend11248153descend
eked96718033__eke_d
emend86214893__emend
expend16247503_expend
extend14267523_extend
feezed19439993feeze_d
gecked146911933gecke_d
gleeked13346333gleeke_d
headend12398363headend
heeded114215763heede_d
heeled104018423heele_d
heezed194210513heeze_d
jeeped16469843jeepe_d
jeered143912793jeere_d
jerked18479593jerke_d
kecked125113173kecke_d
keeking114210893keeking
keeled114414273keele_d
keened114013633keene_d
leaked114217703leake_d
leered73816223leere_d
legend837693_legend
lekked10395633lekke_d
meeker12359983meeke_r
meekest1336893meekest
necked134715073necke_d
needed84114443neede_d
peaked136117403peake_d
pecked155019103pecke_d
peeking144414953peeking
peeled94119713peele_d
peened94318163peene_d
peeped113915393peepe_d
peered93819493peere_d
peeved124112893peeve_d
perked134617693perke_d
perpend12259353perpend
prebend12319443prebend
pretend104011013pretend
reblend1036653reblend
recked134821803recke_d
reeded84022563reede_d
reefed103816583reefe_d
reeker103715593reeke_r
reekers113613143reekers
reeking123318643reeking
reeled74725533reele_d
reeved104118713reeve_d
relend76116453_relend
remend95216553_remend
repetend1136223repetend
resend75016773_resend
reverend12288853reverend
seeded84520463seede_d
seeker103615363seeke_r
seekers113712333seekers
seeking124016063seeking
seeled73922093seele_d
seemed95117613seeme_d
seeped94317523seepe_d
sleeked123510883sleeke_d
sleeken11326803sleeken_
sleekened1442543sleekened
sleekens12274873sleekens
smeeked14287223smeeke_d
steeked124010473steeke_d
sweeten10267313sweeten_
sweetened1343253sweetened
sweetens11255433sweetens
teemed95114873teeme_d
tweaked1534403tweake_d
tweeted11336583tweete_d
tweezed20274993tweeze_d
unkend11309223_unkend
veered103612743veere_d
waked135626753w_ake_d
waken124818473w_aken_
wakened1546873w_akened
wakens135012043w_akens
walked145313783walke_d
wanked144517153wanke_d
warked144421213warke_d
wauked144210573wauke_d
weakener1534913weakener
weaker134015443weake_r
weakest1439003weakest
weakon13357623weakon_
weakons14287803weakons
weaned103816153weane_d
weasand1135503weasand
weaved133913483weave_d
weazand2043613weazand
webbed1436433webbe_d
webfed1535033webfe_d
wedded123811843wedde_d
wedeled1237783wedele_d
wedged125110303wedge_d
weed85637513w_e_e_d
weeder103315513weede_r
weeders113412933weeders
weeding123815213weeding
week116428153week___
weekday1841963weekday
weekenders1842263weekenders
weekending1942233weekending
weeklong1641323weeklong
weekly1635313week_ly
weeks125017863week__s
ween75835463w_e_en_
weening114113973weening
weens85224053w_e_ens
weeny115316163w_e_eny
weeper114313303weepe_r
weepers123511973weepers
weeping133613673weeping
weeting113816053weeting
weever123811443weeve_r
weevers13379993weevers
weewee12310093weewe_e
weewees1336573weewees
welded114013383welde_d
welkin1337313welkin_
welkins1437173welkins
welled103820213welle_d
welted103715823welte_d
wend85330453w___end
wended113616153wende_d
wergeld1233183wergeld
wessand1144833wessand
wetland1135353wetland
wetted103717023wette_d
wheeled14318473wheele_d
wheen115016053whe_en_
wheens124610613whe_ens
wheeped16387513wheepe_d
wheezed23296463wheeze_d
wicked164317413wicke_d
winked144018603winke_d
woken124614973w_oken_
worked145314703worke_d
wreaked15369023wreake_d
wrecked17418333wrecke_d
yearend11285703yearend
yerked14509373yerke_d
yeuked14456233yeuke_d

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.406440125.6
2DLD Change Limit1340271767.34318252.3
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.