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

56 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
thallium134443(None) 
thalliums1443251thalliums
allium8311242__allium
gallium1037942_gallium
pallium1149012_pallium
phallism1545712phallism
thalli958922thalli__
thallic1246552thalli_c
thallious1243272thallious
thallous1136522thallous
thallus1035602thall_us
thulium1254472th_ulium
trillium1046202trillium
alliums957973__alliums
bdellium1342733bdellium
calcium1368593_calcium
challie124012853challi_e
challies133915643challies
challis124613463challi_s
chillum1435443chill_um
galliums1145963_galliums
hafnium1544243_hafnium
hahnium1544433_hahnium
hallux1637363_hall_ux
hassium1236133_hassium
helium112311253_h_elium
holmium1445443_holmium
kalium1239473_ka_lium
palliums1236703_palliums
phalli1148263phalli__
phallic1447293phalli_c
phallisms1645073phallisms
phallist1338983phallist
phallus1236063phall_us
prothallium1852593prothallium
psyllium1543033psyllium
talcum1036953t_a_lcum
tallied83314753t_allied
tallier72817213t_allier
tallies73624603t_allies
tallis63319963t_alli_s
tallish103313583t_allish
tallisim1074983t_allisim
tallit63422733t_alli_t
tallith102913063t_allith
tallitim1065503t_allitim
tallits73215993t_allits
telium82611393t__elium
thairm1156963tha__irm
thalamus1343603thalamus
thalloid1246283thalloid
thorium12208413th_orium
thralldom1551283thralldom
thralling13256833thralling
thuliums1343553th_uliums
trilliums1144333trilliums

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162566.82621412.5
3Display Results56560.0331697.0
 (SQL Overall)178691567.01525472.7
 
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.