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

152 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
tectums1130642(None) 
rectums11338521rectums
tectum10328601tectum_
centums11398782centums
dictums1235552dictums
rectum103411282rectum_
rectus83314632rectu_s
septums1135742septums
tediums10266972tediums
tetotums10124062tetotums
acetum1038463acetum_
aecium10410423aecium_
becalms1335743becalms
begums11429493be_gums
bestuds10326753bestuds
cactus104912233cactu_s
cecum11611843cec_um_
centrums1236913centrums
centum104012363centum_
ceriums1139473ceriums
cesiums1136303cesiums
cestus84412913cestu_s
chums125015833__chums
datums936353_datums
decorums1344993decorums
degums10438623de_gums
dictum1136863dictum_
ecrus75113863_ecru_s
ecus65421463_ec_u_s
electrums1344483electrums
estrums9208603_estrums
etuis54013133_e_tuis
ferrums1265983ferrums
fetus85816543fe_tu_s
getups9346853ge_tups
geums85414113ge__ums
hectors123513263hectors
heliums12188303heliums
ictus7249703_ictu_s
lactams1136953lactams
lectins92515003lectins
lectors93415763lectors
lecture9149513lecture
lectures101310153lectures
letups8317683le_tups
locums10478303loc_ums
luteciums1343123luteciums
lyceums1442403lyceums
meatus85112923meatu_s
mediums12308723mediums
mentum104511713mentum_
metump1235713me_tump
metumps1334133me_tumps
nectars938463nectars
neums75414253ne__ums
oestrums10156473oestrums
omentums1243973omentums
pectens11189203pectens
pectins112315233pectins
peplums13145503peplums
plectrums1553033plectrums
recoups1188843recoups
rectors93520513rectors
rectos85718783rect_os
recurs83315803rec_urs
recuts83817373rec_uts
retems83914573re_tems
rictus8379193rictu_s
sacrums11388043sacrums
sanctums1244013sanctums
scrums104614253_scrums
scums95017423_sc_ums
sebums10369813se_bums
sectors93116443sectors
sects75622893sect__s
sedums93910483se_dums
septum1038003septum_
serums83916303se_rums
setups83910463se_tups
spectrums1543173spectrums
sternums1045783sternums
stewbums1542103stewbums
stickums1643943stickums
stratums10266803stratums
stums75320083__stums
tactics1149323tactics
tacts76524123tact__s
tactual936203tactual
talcums1135513talcums
tantrums1045113tantrums
teacups1133963teacups
teams75726513te__ams
teatime9310083teatime
teatimes1039443teatimes
teats55636813teat__s
techies12513603techies
technos1236183technos
techs106915833tec__hs
tecta74215523tect__a
tectal83713253tect_al
tectite9310583tectite
tectites1039993tectites
tectrix1644263tectrix
tedium9269873tedium_
teems76019783te__ems
teeters74018303teeters
teethes103611653teethes
teetotums11162563teetotums
teguas768013te_guas
telium82611393telium_
tendus75111183tendu_s
tenours72610073tenours
tenters73921103tenters
tenths94412663tent_hs
tents56434213tent__s
tenues63816443te_nues
tenuis64213083te_nuis
tenutos736623tenutos
terbiums1245423terbiums
tergum937933tergum_
terms75523473te__rms
testees74215913testees
testers74124543testers
testes65125823test_es
testis64916713test_is
testons7313563testons
tests56530193test__s
testudo843363testudo
testudos943053testudos
teths85418513te_t_hs
tetotum9134613tetotum_
tetras63017623te_tras
tetris62816293te_tris
tets45847463te_t__s
tetters74320473tetters
texts125515043text__s
textual1444603textual
texture1497083texture
textures1597523textures
thrums11429123t_hrums
tictacs1145793tictacs
tictocs1145903tictocs
tittups933353tittups
totems86810763t_otems
tritiums1056393tritiums
tuchuns1233983tuchuns
tutus55214813t_utu_s
vacuums1443403vacuums
vectors123212593vectors
vellums1235293vellums
vertus94613603vertu_s
victims1436003victims

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.1731032896.0
2DLD Change Limit1340271526.84319586.0
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.07925242.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.