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

156 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
semesters113912(None) 
semester1038901semester_
bimesters1336342bimesters
cementers1338312cementers
deemsters1285022deemsters
demisters1249202demisters
dempsters1435272dempsters
detesters10298302detesters
gamesters1236732gamesters
keesters12319592ke_esters
remasters11310582remasters
rimesters1137482rimesters
seamsters1136332seamsters
sequesters1943842sequesters
smelters103310512s_melters
ammeters1237693amme_ters
arresters948193arresters
attesters935803attesters
begetters12135043begetters
besetters11136643besetters
bimester1236163bimester_
celestes10310013celeste_s
cementer1239193cementer_
cemetery1554923ceme_tery
decenters122410373decenters
deemster1175713deemster_
defeaters13289103defeaters
delusters1035983delusters
demergers13146403demergers
demesnes1137083demesne_s
demister11310223demister_
dempster1355773dempster_
deserters10129983deserters
detecters12217753detecters
detester9239683detester_
diesters92513603_diesters
digesters11257883digesters
dimeters11411093dime_ters
dopesters1237283dopesters
dumpsters1453743dumpsters
easters75125683_e_asters
emeers83314183_eme__ers
emenders11319033_emenders
emeses86114963_emes_e_s
emeutes938013_emeute_s
emitters10349643_emitters
emoters94712873_em_oters
erecters102611613_erecters
esters64627733___esters
feasters11511563fe_asters
fermenters15116533fermenters
festers104121393__festers
fomenters1437853fomenters
foresters12312533foresters
gamester1137323gamester_
geometers1238193geome_ters
hamsters13710423ham_sters
heisters113413133he_isters
hemipters1645683hemipters
infesters12237713infesters
jesters144118193__jesters
jokesters2044443jokesters
keester11319913ke_ester_
keisters123212043ke_isters
keysters15326333ke_ysters
kiesters123310153_kiesters
lamenters1137683lamenters
lamisters1157123lamisters
lamsters1099753lam_sters
leisters83312823le_isters
masters94628923__masters
meeters94714543__meeters
meisters103313843me_isters
melters93918313__melters
mestees94617753__mestees
meters85625833__me_ters
misters93927513__misters
molesters1198873molesters
musters94522513__musters
nemeses948663nemes_e_s
nesters74422793__nesters
pensters103012123pe_nsters
pesters93827093__pesters
presters103419003_presters
questers17168763_questers
reenters82915303re_enters
registers1038893registers
reheaters122010273reheaters
rejecters18257543rejecters
reletters9138783reletters
remaster10311473remaster_
remembers1544493remembers
remitters11328403remitters
repeaters112811993repeaters
repenters112511553repenters
requesters1944323requesters
resetters9129463resetters
resisters9310453resisters
resters74130403__resters
reverters122710433reverters
rhymesters1842603rhymesters
rimester1037813rimester_
scamsters1334993scamsters
scepters1237793s_cepters
seamster1037143seamster_
seaters74028943s__eaters
seawaters1235713seawaters
seceders11277963sece_ders
seedeaters1144903seedeaters
seeders83017113se_e_ders
seekers113712333se_e_kers
seemers93814333se_e_mers
seisers73816393se_is_ers
selectees1147013selectees
selectors1148973selectors
sememes11109203seme_me_s
semestral1185293semestral
semises93916553semis_e_s
sempstress1452193sempstress
sequester1844443sequester_
sestets7911473s__estets
setters73822063s__etters
sheeters113111863s_heeters
shelters113412813s_helters
shysters14106463s_hysters
sidesteps1243623sidesteps
sisters73721593s__isters
skeeters12298963s_keeters
skelters12349373s_kelters
smashers13339593s_mashers
smatters104011713s_matters
smearers10308623s_mearers
smellers10329773s_mellers
smelter93311913s_melter_
smeltery13274963s_meltery
smiters93414363s_m_iters
songsters1046113songsters
specters122811063s_pecters
speedsters1342813speedsters
spelters103912243s_pelters
spinsters1136613spinsters
spymasters1742803spymasters
suggesters1243433suggesters
sumpters1238023sum_pters
sweaters113811063s_weaters
swelters113110193s_welters
teamsters1135973teamsters
teeters74018303te_e_ters
tempters12257293tem_pters
testers74124543__testers
trimesters1245413trimesters
webmasters1742913webmasters
websters1335803we_bsters
westers105221963__westers
wresters112711733_wresters
zesters163517293__zesters

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411567.08020994.5
3Display Results1561560.0801950.0
 (SQL Overall)1786911567.59623524.4
 
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.