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

206 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
tergum93793(None) 
begum105213922be_gum
cerium10313762cerium
degum94711902de_gum
ferrum1147452ferrum
iterum837902iter_um
serum75223472ser_um
sternum947732sternum
tectum10328602tectum
tedium9269872tedium
tegua6109562te_gua
telium82611392telium
terbium1147292terbium
terga63315642terg_a
tergal72912832tergal
term66233152ter__m
thrum104713632thr_um
aecium10410423aecium
aerugo735803aerugo
algum82711763_algum
apterium1249133apterium
argue64818443_argue
argus66716543_argus
arum66129033_ar_um
atrium8411823atrium
aurum7614963aur_um
barium10313513barium
begrim11118333begrim
begums11429493be_gums
begun85113443be_gun
berg75425543berg__
bergs84718043berg_s
berm86732753ber__m
cecum11611843ce_cum
centum104012363centum
cercus105013153cercus
cereus85215523cereus
ceriums1139473ceriums
cerous85821203cerous
cesium1039583cesium
corium10315723corium
curium10312503curium
dadgum1134583dadgum
degums10438623de_gums
dengue838253dengue
derm76031893der__m
dirdum1036033dirdum
dorsum947623dorsum
drum76521593_dr_um
durum8513203dur_um
erbium1038083_erbium
erg45531073_erg__
ergo56420153_erg_o
ergot65422893_ergot
ergs55523813_erg_s
erugo6369853_erugo
exergue1544193exergue
ferbam1339003ferbam
fermium1446353fermium
ferrums1265983ferrums
forum108318763for_um
frenum1188803frenum
germ75428963ger__m
geum75424553ge__um
grum75625083_gr_um
gum67439533___gum
helium112311253helium
herm95636153her__m
jorum145513743jor_um
jugum15167473_jugum
larum74317973lar_um
league758743league
legume936913le_gume
medium113711623medium
megrim1178043megrim
mentum104511713mentum
merge84523693merg_e
merged104214953merged
mergee94018143mergee
merger95016483merger
merges94122493merges
morgue938113morgue
negus64513563ne_gus
neum66723083ne__um
peplum12156823peplum
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
perfume1446503perfume
perfumy1763933perfumy
perm85834633per__m
pterygium1751923pterygium
reargue836463reargue
rectum103411283rectum
regnum957163regnum
rerun58722153rer_un
rum56644643__r_um
sagum8512873_sagum
scrum95418203scr_um
sebum93814553se_bum
sedum84115573se_dum
segue6314413se_gue
sensum849353sensum
septum1038003septum
serge64727473serg_e
serged84118773serged
serger73819743serger
serges74225973serges
serous65023563serous
serums83916303ser_ums
sorghum1343513sorghum
sternums1045783sternums
stewbum1442943stewbum
strum75619453str_um
subgum1136133subgum
talcum1036953talcum
targe65227093targ_e
targes74524593targes
target75028903target
tarsus6310513tarsus
teacup1036253teacup
team66238653te__am
tearful1046033tearful
teargas837013teargas
tearoom939063tearoom
tectums11306423tectums
tediums10266973tediums
teem66132603te__em
teg45741623te_g__
tegg65315923te_g_g
teggs74710743te_ggs
tegs56031493te_g_s
teguas768013te_guas
tegumen10105423te_gumen
tendu67216003tendu_
tendus75111183tendus
tenge65720443teng_e
tenour62610733tenour
terai53525483ter_ai
terais64023513terais
teraohm1244783teraohm
teraph11319093teraph
terbia8311153terbia
terbic10410963terbic
terbiums1245423terbiums
terce75721843ter_ce
tercel83612993tercel
terces83921413terces
tercet83624913tercet
teredo7310783teredo
terete6319333terete
tergite8311003tergite
termed94816703termed
termer85717253termer
termly1138433termly
termor84412513termor
terms75523473ter_ms
tern46134803ter__n
terne56426153ter_ne
ternes65422903ternes
terns55226873ter_ns
terra54419663ter_ra
terrae62915213terrae
terras63516973terras
terret63425623terret
territ63421373territ
terror63811733terror
terry84721873ter_ry
terse55026823ter_se
terser67317823terser
tetotum9134613tetotum
teugh95511613teug_h
therm106018023ther__m
thorium12208413thorium
thru76818943thr_u_
thrums11429123thr_ums
togue64816303t_ogue
tongue7410093tongue
torous64319033torous
torque15237673torque
torus54329763tor_us
tragus749233tragus
tram67034553t_r_am
trauma838803t_rauma
trim65329523t_r_im
trout57332573t_rout
true46725853t_r_ue
trug55720043t_r_ug
trugs65516803t_rugs
trump95615123t_r_ump
turgid868013turgid
turgor736863turgor
turnup835093turnup
uterus639203uter_us
vellum1136773vellum
velum10713383ve_lum
verge93419843verg_e
verged114815163verged
verger104315703verger
verges104320183verges
verism113214263verism
versus94211143versus
vertu85017613vertu_
vertus94613603vertus
xerus12313333xer_us
yttrium1244103yttrium

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162065.78019501.0
3Display Results2062060.0633269.8
 (SQL Overall)1786912066.21928733.1
 
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.