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

67 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
lithium124582(None) 
lithiums1344311lithiums
lithia939332lithi_a
lithias1038822lithias
lithic1139492lithi_c
lithify1644762lithify
atrium8411823_atrium
bothrium1585013bothrium
cilium104311373ci_lium
ditheism1446053ditheism
dithiol1145433dithiol
elitism939763elit_ism
ilium74614183_i_lium
indium939503_indium
ionium8610923_ionium
ischium1444243ischium
iterum837903_iterum
kithing153411553kithing
labium10410243l_abium
lathi85417203lathi__
lathier10310833lathier
lathing114315693lathing
lathis95516173lathi_s
lichi104412953lichi__
lichis115212593lichi_s
linum7313823li__num
litai55216363litai__
litchi1137893litchi__
litchis1238373litchi_s
lithe84922013lith__e
lithely1356643lithely
lither94520953lith_er
lithest10513913lithest
litho86513783lith__o
lithoed1137833lithoed
lithoid1148773lithoid
lithoing1236743lithoing
lithops12307253lithops
lithos94212553lith_os
litmus836323lit_mus
litu47631563lit__u_
lixivium2052223lixivium
lutecium1244393lutecium
lutetium1044243lutetium
luteum837783lut_eum
luthier1038233luthier
milium104712683mi_lium
minium106014423mi_nium
natrium948983natrium
niobium1144723niobium
oidium959813oi_dium
ostium8310133ost_ium
pithier123010293pithier
pithily1567033pithily
pithing134014053pithing
stibium1145843stibium
thrum104713633__thrum
titanium1046033titanium
tithing113513893tithing
tritium969013trit_ium
withier132910493withier
withies133913543withies
within123611383withi_n
withing143814493withing
withins133511693withins
without1348883without
yttrium1244103yttrium

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 Limit134027676.57620381.2
3Display Results67670.0332030.3
 (SQL Overall)178691676.99925530.9
 
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.