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 “holmium” 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
holmium144543(None) 
holmiums1544151holmiums
folium11310452fol_ium
helium112311252hel_ium
holism113713742hol_ism
holmic1338772holmi_c
osmium1036572_osmium
allium8311243_allium
alodium1047583alodium
bohrium1475013bohrium
cadmium1446113cadmium
calcium1368593calcium
chromium1745973chromium
cilium104311373cil_ium
columbium1743223columbium
conium10415313co_nium
coremium1446413coremium
corium10315723co_rium
cosmism1337013cosmism
fermium1446353fermium
foliums1237173fol_iums
gallium1037943gallium
gonium949803go_nium
hafnium1544243hafnium
hahnium1544433hahnium
hassium1236133hassium
heliums12188303hel_iums
helming133712003helming
hilum105514603hil__um
hoboism1446613hoboism
hokum1436763ho__kum
holding123514283holding
holdout11510893holdout
holdup1245183hol_dup
holibut1297483holibut
holier94921623hol_ier
holies94630033hol_ies
holily123612953hol_ily
holing104025073hol_ing
holisms123811113hol_isms
holist94723213hol_ist
holking153512313holking
hollies103420813hollies
holm95628103hol___m
holms105117803holm__s
homie104622523ho_mi_e
homier116416993ho_mier
homies114524723ho_mies
homily144712333ho_mily
homing123718383ho_ming
hominy144511483ho_miny
hoodlum1343813hoodlum
ilium74614173_il_ium
ionium8610913io_nium
kalium1239473kal_ium
milium104712673mil_ium
momism93410353mo_mism
nomism103010953no_mism
odium83413033_o_dium
oidium959813_oidium
oleum73613323_ol_eum
onium73115533_o_nium
opium92812093_o_pium
osmiums1134143_osmiums
ostium8310133_ostium
pallium1149013pallium
podium112911913po_dium
polonium1248333polonium
premium13310363premium
rhodium1345333rho_dium
scholium1545633schol_ium
sodium92111443so_dium
solanum946403solanum
solarium1078263solarium
solatium1067603solatium
solum74717603sol__um
telium82611393tel_ium
thallium1344433thallium
thorium12208403tho_rium
thulium1254473thul_ium
wholism1535873whol_ism
yomim12510073yo_mi_m
zoarium1846093zoarium
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 Limit134027847.22018563.3
3Display Results84840.0302800.0
 (SQL Overall)178691847.40624127.9
 
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.