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

84 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
alodium104758(None) 
allodium1145781allodium
allium8311242al_lium
alodia71112452alodi_a
alodial899952alodial
caladium1347022caladium
odium83413032__odium
podium112911912_podium
rhodium1345342rhodium
sodium92111452_sodium
aboding11410123aboding
aconitum1243743aconitum
aecidium1345283aecidium
aecium10410423a_ecium
aerobium1246303aerobium
alarum85411983al_arum
album92312653al__bum
algorism1147353algorism
algum82711763al__gum
alliums957973al_liums
allodia8128793allodi_a
allodial9117393allodial
alluvium1343993alluvium
aloin55227423alo_i_n
aloins65022203alo_ins
aloud65018073alo__ud
alum65227613al___um
aluminum1274563aluminum
alyssum1242473alyssum
ammonium1145883ammonium
anodic92813133anodi_c
anodize1738683anodize
anthodium1545043anthodium
apodous1037403apodous
ascidium1344813ascidium
atomism112610963atomism
atrium8411823a_trium
avodire1143763avodire
basidium1345103basidium
caladiums1444633caladiums
calcium1368593cal_cium
cladism1238553cladism
clonism1138983clonism
conium10415313_conium
corium10315723_corium
eluvium1244973eluvium
eulogium1144613eulogium
exordium1844003exordium
folium11310453_folium
gallium1037943gal_lium
gonium949803_gonium
holmium1445443holmium
hoodlum1343823hoodlum
ilium74614183il__ium
indium939503_indium
iodism93611133_iodism
ionium8610923_ionium
iridium1046303iridium
kalium1239473kal__ium
labium10410243_labium
locum94812173_lo_cum
medium113711623_medium
modicum1445073_modicum
muonium1146863muonium
niobium1144723niobium
odeum84610543__odeum
odiums9337943__odiums
oidium959813_oidium
onium73115533__onium
opium92812093__opium
palladium1444433palladium
pallium1149013pal_lium
paludism1345323paludism
podiums12227633_podiums
polonium1248333polonium
protium11312293protium
radium93513293_radium
rhodiums1443763rhodiums
sodiums10177213_sodiums
stadium1038073stadium
tedium9269873_tedium
thorium12208413thorium
uredium1076693uredium
vanadium1444713vanadium

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.406440125.6
2DLD Change Limit134027846.67320085.0
3Display Results84840.0302800.0
 (SQL Overall)178691847.10925135.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.