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

191 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
aecium1041042(None) 
acetum1038462acetum
aecia73819282aeci_a
aecial84817312aecial
aecidium1345282aecidium
allium8311252allium
atrium8411832atrium
caecum1238182caec_um
caesium1158832caesium
calcium1368592calcium
cecum11611842cec_um
cerium10313772cerium
cesium1039582cesium
helium112311252helium
medium113711622medium
rectum103411282rectum
tectum10328602tectum
tedium9269872tedium
telium82611402telium
zoecium2044182zoecium
accrue1035823accrue
acid77533403a_ci_d
acids87121013a_cids
acidy117214903a_cidy
acing87429153a_cing
acini75718983a_cini
acinus8311253a_cinus
adytum1243733adytum
aecidia1047293aecidia
aedile73716653aedile
aedine73218393aedine
aegis6316783aegi_s
aeneus61111143aeneus
aerial64625713aerial
aerie54634603aeri_e
aeried74221873aeried
aerier64823163aerier
aeries64737783aeries
aerify122810113aerify
aerily93017013aerily
aerobium1246303aerobium
affirm1435523affirm
ageism968803ageism
agendum1144673agendum
agism84614063a_gism
aim57858223a__i_m
alarum85411983alarum
album92312653a_lbum
alcid85817973alci_d
alcids94812293alcids
algum82711763a_lgum
alliums957973alliums
alodium1047583alodium
alum65227613a__lum
americium1554083americium
amicus103810003amicus
amylum1344693amylum
antrum8611313antrum
apterium1249153apterium
arcanum1176443arcanum
arcing95819643arcing
arcus76918863arc_us
arum66129033a__rum
asarum84610913asarum
asci66519143asci__
ascidium1344813ascidium
ascus75013583asc_us
asylum1144893asylum
atriums939063atriums
aurum7614963a_urum
autecism1247073autecism
autism83815333autism
axiom143913593a_xiom
barium10313523barium
becalm1239203becalm
bedim10313833bedi_m
begum105213923be_gum
cadmium1446113cadmium
caesiums1245533caesiums
calciums1446163calciums
cambium1537323cambium
cecity1398153cecity
centum104012363centum
ceriums1139483ceriums
cesiums1136303cesiums
chum116318003__chum
cilium104311373cilium
conium10415313conium
corium10315723corium
cum76440163__c_um
curium10312503curium
decide104116873decide
decidua1144493decidua
decile94619213decile
decorum1246943decorum
degum94711903de_gum
deism84116033de_ism
denim85518843deni_m
dictum1136863dictum
ecru65819533_ecru_
ecrus75113863_ecrus
ecu56828233_ec_u_
ecus65421463_ec_us
erbium1038083erbium
fascism1436443fascism
fecial114714623fecial
fermium1446353fermium
ferrum1147453ferrum
folium11310453folium
francium1545623francium
gallium1037953gallium
genius74512923genius
geum75424553ge__um
gonium949803gonium
gynaecium1751923gynaecium
gynecium1642853gynecium
hafnium1544243hafnium
hahnium1544433hahnium
hassium1236133hassium
heliums12188303heliums
ilium74614183_ilium
indium939503indium
ionium8610923ionium
ischium1444243ischium
kalium1239473kalium
kelim11912553keli_m
labium10410243labium
laicism1138243laicism
locum94812173loc_um
lutecium1244393lutecium
lyceum1343953lyceum
meconium1447313meconium
mediums12308723mediums
medius93613283medius
mentum104511713mentum
milium104712683milium
minium106014423minium
narcism1188733narcism
natrium948993natrium
neum66723083ne__um
odium83413033_odium
oidium959813oidium
onium73115533_onium
opium92812093_opium
osmium1036573osmium
ostium8310133ostium
pallium1149023pallium
panicum1346393panicum
parecism1458543parecism
peculium1455543peculium
peplum12156823peplum
podium112911913podium
premium13310363premium
racism103214193racism
radium93513293radium
recipe103414893recipe
recit75235103reci_t
recite83625113recite
recits83621363recits
recoup10810373recoup
rectums11338523rectums
rectus83314633rectus
recur74116843rec_ur
recut74729243rec_ut
refilm114311403refilm
regius7311923regius
regnum957163regnum
rhenium1246243rhenium
sacrum103910143sacrum
sanctum1145293sanctum
scrum95418203_scrum
scum85924523_sc_um
sebum93814553se_bum
sedum84115573se_dum
seism75019023se_ism
sensum849353sensum
septum1038003septum
serum75223473se_rum
sexism15227653sexism
sodium92111453sodium
talcum1036953talc_um
tectums11306423tectums
tediums10266973tediums
terbium1147293terbium
tergum937933tergum
uredium1076693uredium
vacuum1334833vacuum
vellum1136773vellum
velum10713383ve_lum
verism113214263verism
zooecium2142683zooecium

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.406440125.6
2DLD Change Limit1127161915.53020382.6
3Display Results1911910.0633031.7
 (SQL Overall)1786911915.99929786.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.