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 “rhenium” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
rhenium124624(None) 
rheniums1344411rheniums
helium112311252_helium
rheum1038842rhe__um
rhodium1345332rhodium
ruthenium1453032ruthenium
aecium10410423_aecium
agendum1144673agendum
argentum1145363argentum
atheneum1363223atheneum
biennium1263433biennium
caesium1158833caesium
centum104012363_centum
cerium10313763_cerium
cesium1039583_cesium
chemism16339303chemism
chetrum1445333chetrum
conium10415313_conium
cranium11911103cranium
denim85518843_deni_m
dubnium1244183dubnium
fraenum1255703fraen_um
frenum1188803fren_um
genius74512923_genius
gonium949803_gonium
hafnium1544243hafnium
hahnium1544433hahnium
heliums12188303_heliums
hymenium1874773hymenium
ionium8610913_ionium
medium113711623_medium
mentum104511713_mentum
minium106014413_minium
muonium1146863muonium
omentum1155933omentum
onium73115533__onium
phenix1837133pheni_x
phenom1339473phen_om
plenism11310113plenism
plenum1039503plen_um
premium13310363premium
radium93513293r_adium
ramentum1244863ramentum
rectum103411283r_ectum
refilm114311403r_efilm
regius7311923r_egius
regnum957163r_egnum
renig64518913r_eni_g
renigs74314593r_enigs
renin54830033r_eni_n
renins64526453r_enins
rhesus936203rhe_sus
rheums1135463rhe__ums
rheumy1433353rhe__umy
rhodiums1443763rhodiums
rutheniums1562313rutheniums
selenium1048203selenium
sensum849353_sensum
splenium1246473splenium
tedium9269873_tedium
telium82611393_telium
theism1139483the_ism
thorium12208403thorium
thulium1254473thulium
triennium1143323triennium
uranium9610023uranium
uredium1076693uredium
zoecium2044183zoecium

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.1561145455.1
2DLD Change Limit134027687.09618887.7
3Display Results68680.0135230.8
 (SQL Overall)178691687.26524596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.