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

92 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
terbium114729(None) 
erbium1038081_erbium
terbiums1245421terbiums
aerobium1246302aerobium
cerium10313762cer_ium
erbiums1135462_erbiums
fermium1446352fermium
tedium9269872te_dium
telium82611392te_lium
terbia8311152terbi_a
terbias9310742terbias
terbic10410962terbi_c
tergum937932ter_gum
ytterbium1652222ytterbium
aecium10410423ae_cium
apterium1249133apter_ium
atrium8411823atr_ium
barium10313513bar_ium
cambium1537323cambium
cerebrum1443793cerebrum
ceriums1139473cer_iums
cesium1039583ce_sium
corium10315723cor_ium
curium10312503cur_ium
derbies103016053derbies
ferbam1339003ferb_am
fermiums1544353fermiums
ferrum1147453fer_rum
geranium1147053geranium
gerbil938343gerbi_l
gerbils1037303gerbils
helium112311253he_lium
herbarium1644833herbarium
herbier1239593herbier
heroism12311013heroism
iterum837903iter__um
kerbing14308483kerbing
labium10410243_labium
medium113711623me_dium
niobium1144723niobium
peridium1349023peridium
premium13310363premium
pterygium1751923pterygium
sebum93814553se_b_um
serum75223473ser__um
sternum947733ster_num
stewbum1442943stewb_um
stibium1145843stibium
tectum10328603te_ctum
tediums10266973te_diums
terai53525483terai__
terais64023513terai_s
teraohm1244783teraohm
teratism10312173teratism
terebic1137983terebi_c
tergite8311003tergite
term66233153ter___m
terming104016003terming
termini93410813termini
terminus1037393terminus
termite9313893termite
ternion739493ternion
terrarium1145353terrarium
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrine72517573terrine
territ63421373terri_t
territs72714503territs
tertial7313863tertial
tertian7511193tertian
tetotum9134613tetotum
thorium12208413thorium
thrum104713633thr__um
thulium1254473thulium
trim65329523t_r_i_m
tritium969013tritium
trivium1256143trivium
truism8118623t_ruism
turbid979713turbi_d
turbine9310303turbine
turbit8715113turbi_t
turbith1267113turbith
turbits969233turbits
uredium1076693uredium
verbid122311313verbi_d
verbids13259203verbids
verbify1834993verbify
verbile1249863verbile
verism113214263ver_ism
ytterbiums1751863ytterbiums
yttrium1244103yttr_ium

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.390458182.1
2DLD Change Limit134027926.83019623.3
3Display Results92920.0303066.7
 (SQL Overall)178691927.25024647.0
 
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.