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

194 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
semester103890(None) 
semesters1139121semesters
bimester1236162bimester
cementer1239192cementer
deemster1175712deemster
demister11310222demister
dempster1355772dempster
detester9239682detester
gamester1137322gamester
keester11319912ke_ester
remaster10311472remaster
rimester1037812rimester
seamster1037142seamster
sequester1844442sequester
smelter93311912s_melter
ammeter1148393amme_ter
arrester839253arrester
attester836503attester
begetter11136313begetter
bemisted1368383bemisted
besetter10137973besetter
bimesters1336343bimesters
celeste949653celeste_
celestes10310013celestes
cemented1338373cemented
cementers1338313cementers
cemetery1554923ceme_tery
decenter112412163decenter
deemsters1285023deemsters
defeater122611663defeater
deluster936903deluster
demasted1238763demasted
demented12311273demented
demerger12127373demerger
demesne1035573demesne_
demesnes1137083demesnes
demisters1249203demisters
dempsters1435273dempsters
deserter91211603deserter
detecter11298733detecter
detested10279623detested
detesters10298303detesters
devested13239133devested
diester83013683_diester
digester10258433digester
dimeter10411893dime_ter
dopester1137253dopester
dumpster1344053dumpster
easter65027983_e_aster
egested938123_egested
emeer74815363_eme__er
emender10649843_emender
emeses86114963_emes_es
emeute838533_emeute_
emeutes938013_emeutes
emitter93211083_emitter
emoter85415193_em_oter
erecter93113393_erecter
ester54727713___ester
feaster10812983fe_aster
fermenter1497543fermenter
fester94723513__fester
fomenter1339263fomenter
forester11313673forester
gamesters1236733gamesters
geometer1138423geome_ter
hamster12810423ham_ster
heister103613623he_ister
hemipter1545583hemipter
honester1139713honester
infester11239433infester
jester134319153__jester
jokester1934443jokester
keesters12319593ke_esters
keister113011573ke_ister
keyster14256153ke_yster
kiester11329973_kiester
lamenter1038863lamenter
lamister1037653lamister
lamster9109913lam_ster
leister73212753le_ister
master84831343__master
meeter83616503__meeter
meister93114163me_ister
melter83520113__melter
mestee84523883__mestee
meter75130323__me_ter
mister84728563__mister
modester1197483modester
molester1099373molester
muster84724523__muster
nemeses948663nemes_es
nester64124183__nester
penster92811953pe_nster
pester84827593__pester
prester93519623_prester
quester161410023_quester
recenter102715443recenter
reenter73217793re_enter
reested82916233re_ested
register939553register
reheater113413033reheater
rejecter17258943rejecter
reletter81311023reletter
remasters11310583remasters
remelted11310153remelted
remember1434623remember
remitter102810323remitter
remoter94815973rem_oter
renested92212953renested
repeater102615443repeater
repenter102813863repenter
requester1855513requester
resetter81511833resetter
resister8311653resister
rester63832433__rester
retested92212533retested
reverter114812873reverter
revested122612243revested
rhymester1742393rhymester
rimesters1137483rimesters
scamster1235303scamster
scepter1138363s_cepter
seamsters1136333seamsters
seater64534163s__eater
seawater1136603seawater
seceder10329573sece_der
secreter1038513secreter
sedater83713633se_dater
seedeater1045973seedeater
seeder74320773se_e_der
seedier83513633se_edier
seeker103615363se_e_ker
seemer84418043se_e_mer
seemlier1035193seemlier
seepier92912013se_epier
segmented1345063segmented
seiser65318343se_is_er
selected1159783selected
selectee10910493selectee
selector1048613selector
sememe10129983seme_me_
sememes11109203seme_mes
semes75731583semes___
semestral1185293semestral
semises93916553semis_es
sequesters1943843sequesters
serener73415763sere_ner
serest64831613serest__
sestet6826203s__estet
setter64023723s__etter
severer103511563seve_rer
sheeter103814913s_heeter
shelter103214963s_helter
shyster13116563s_hyster
sidestep1144243sidestep
silenter838873silenter
sinister838583sinister
sister64421583s__ister
skeeter113410413s_keeter
skelter113610003s_kelter
smarter94113133s_marter
smasher123911023s_masher
smatter93613333s_matter
smearer94110403s_mearer
smeller94212783s_meller
smelted10399093s_melted
smelters103310513s_melters
smeltery13274963s_meltery
smiter83616413s_m_iter
songster935793songster
specter113111733s_pecter
speedster1252733speedster
spelter94113703s_pelter
spinster1036683spinster
spymaster1642583spymaster
suggester1143733suggester
sumpter1138873sum_pter
svelter10359673s_velter
sweater103712723s_weater
sweeter103212003s_weeter
swelter103711173s_welter
teamster1036293teamster
teeter65420313te_e_ter
tempested1444033tempested
tempter11358213tem_pter
tester64227153__tester
trimester1145823trimester
webmaster1643003webmaster
webster1236093we_bster
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
zester153617793__zester

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621947.70318974.7
3Display Results1941940.0802425.0
 (SQL Overall)1786911948.21921741.2
 
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.