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

212 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
septum103800(None) 
septums1135741septums
centum104012362centum
mentum104511712mentum
peplum12156822peplum
rectum103411282rectum
scutum1036372scutum
sebum93814552se_bum
sedum84115572se_dum
sensum849352sensum
sept65844362sept__
septa75518082sept_a
septal84513382septal
septet8921132septet
septic102713192septic
septime1138802septime
septs75420602sept_s
serum75223472se_rum
setup73915822se_tup
sputum1035942sputum
stum65526022s__tum
tectum10328602tectum
acetum1038463acetum
adytum1243733adytum
aecium10410423aecium
aseptic1137373aseptic
begum105213923be_gum
bestud9439303bestud
cecum11611843ce_cum
centrum1168603centrum
centu76119413centu_
centums11398783centums
cerium10313763cerium
cesium1039583cesium
cestus84412913cestus
cuprum1236743cuprum
datum8310633_datum
degum94711903de_gum
deperm1139363deperm
deplume1255063deplume
depth114311853dept_h
depths12428573depths
depute94512303depute
deputy12426713deputy
dictum1136863dictum
estrum81810513estrum
etui45416233_e_tui
ferrum1147453ferrum
fetus85816543fe_tus
getup83410263ge_tup
geum75424553ge__um
gypsum1442853gypsum
helium112311253helium
heptad1237273heptad
kept106232943kept__
lept66440883lept__
lepta75714393lept_a
leptin82512333leptin
lepton82510803lepton
letup73712163le_tup
meatus85112923meatus
medium113711623medium
metump1235713me_tump
neum66723083ne__um
notum7611693_notum
oestrum9177783oestrum
omentum1155933omentum
opium92812093_opium
peplums13145503peplums
peplus10138343peplus
peptic122113153peptic
peptid112712373peptid
plum85122103__plum
ptui64912483__ptui
rectums11338523rectums
rectus83314633rectus
regnum957163regnum
replumb1343393replumb
repour8310993repour
repump1235683rep_ump
repute84716093repute
retem74221953re_tem
sacrum103910143sacrum
sagum8512873s_agum
sanctum1145293sanctum
santur6311273santur
sapour83812373sapour
satem76021463s_atem
scepter1138363scepter
sceptic1337833sceptic
sceptre1135053sceptre
scrotum1145133scrotum
scrum95418203s_crum
scum85924523s__cum
seam66645973se__am
seat47575563seat__
seated75131063seated
seater64534163seater
seats54844343seat_s
sebums10369813se_bums
sect67443623sect__
sector83415933sector
sects75622893sect_s
sedums93910483se_dums
seem65438563se__em
seethe93712483seethe
segue6314413se_gue
seism75019023se_ism
seitan62613233seitan
seldom939413seldom
sendup9106343sendup
sent46963013sent__
sente56432883sent_e
senti56226703sent_i
sentimo9449623sentimo
sentry92912053sentry
sepal77723003sep_al
sepals85217373sepals
sepia75318673sep_ia
sepias83616103sepias
sepic94617053sep_ic
sepoy10314303sep_oy
sepoys1138473sepoys
seppuku1541103seppuku
sepses84515883sepses
sepsis83011293sepsis
septage1078403septage
septarium1345163septarium
septate9511873septate
septets998953septets
septics112810433septics
septimes1238303septimes
septuple1242903septuple
serous65023563serous
serums83916303se_rums
sestet6826203sestet
set36681253se_t__
seta45637313se_t_a
setae56026223se_tae
setal56430903se_tal
seton55223543se_ton
setous64917373setous
setout64719463setout
sets45549503se_t_s
sett45949053se_t_t
settee63721023settee
setter64023723setter
settle63915663settle
setts55124323se_tts
setups83910463se_tups
sexism15227653sexism
sext117338093sext__
sextan13389643sextan
sextet13916873sextet
sexto124415453sext_o
sexton133610793sexton
sextos134012163sextos
sexts125118383sext_s
siglum936563siglum
sistrum946563sistrum
situp74414063s_itup
situs55019233s_itus
skellum1343853skellum
skeptic1545203skeptic
slept75728103slept__
slum65430513s__lum
smeddum1342853smeddum
sodium92111453sodium
solum74717613s_olum
spam85930043s_p_am
spasm94514173s_pasm
spectrum1444073spectrum
sperm93216023s_perm
spout75029633s_pout
sprue74717633s_prue
sprug85313893s_prug
spud75818493s_p_ud
spue66025523s_p_ue
spume95817313s_p_ume
spumy124610363s_p_umy
spun66221463s_p_un
spur65321193s_p_ur
sputa74612963s_puta
statue66015323statue
status65515213status
stem610628253s__tem
sternum947733sternum
stewbum1442943stewbum
stratum9318253stratum
strum75619453s_trum
stub66221843s__tub
stud56220093s__tud
stump94616463s__tump
stums75320083s__tums
stun45623453s__tun
subgum1136133subgum
sum56346013s___um
swept105720603swept__
swum96416823s__wum
symptom1644003symptom
system1135743system
tapetum1145393tapetum
tectums11306423tectums
tedium9269873tedium
telium82611393telium
tergum937933tergum
tetotum9134613tetotum
vellum1136773vellum
velum10713383ve_lum
vertu85017613vertu_
vertus94613603vertus
wept95635053wept__

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162125.11022057.9
3Display Results2122120.0762789.5
 (SQL Overall)1786912125.57632046.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.