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 “solanum” 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
solanum94640(None) 
solanums1044431solanums
solan55328152solan__
soland75115042solan_d
solands84412342solands
solanin7311942solanin
solano65314182solan_o
solanos74412852solanos
solans64122492solan_s
solarium1078262solarium
solatium1067612solatium
solum74717612sol__um
alarum85411983_alarum
arcanum1176443arcanum
colonus94413443colonus
fanum10313443__fanum
folium11310453fol_ium
galbanum1343683galbanum
granum9310913_granum
holmium1445443holmium
ladanum1045183ladanum
larum74317973__larum
linum7313823__linum
oakum1177313_o_akum
oleum73613323_ol_eum
olibanum1252363_olibanum
omasum1035503_omasum
organum1045343organum
plenum1039503_plenum
polonium1248333polonium
pomatum1346393pomatum
sagum8512873s__agum
salaam8711013sala_am
selenium1048203selenium
silane62718053silan_e
silanes72517163silanes
silenus7369693silenus
slalom888173s_lalom
slam67737973s_la__m
slang66324023s_lan_g
slangs75615343s_langs
slangy105411393s_langy
slank95822773s_lan_k
slant55238703s_lan_t
slants64819083s_lants
slanty95114843s_lanty
slum65430513s_l__um
sodium92111453so_dium
sola45541863sola___
solace83415823sola_ce
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solander948123solander
solanine8311533solanine
solanins8310513solanins
solar55927343sola__r
solaria7312493solaria
solarism10810383solarism
solariums1165923solariums
solate64526073sola_te
solated83618023solated
solates73523853solates
solatia7312253solatia
soldan73511853soldan__
soldans83210403soldan_s
soleus64615613sol_eus
solidus8338113solidus
soling74226823solin_g
solon55026133solon__
solons65120023solon_s
solums85211333sol__ums
solunar735283solunar
solus54726983sol__us
soman75024903soman__
somans84619303soman_s
sonance9310313sonance
sonant6621953sonan_t
sonants7511233sonants
sorghum1343513sorghum
sowans94215893sowan_s
sphagnum1641533sphagnum
splenium1246473splenium
stannum944643stannum
sternum947733sternum
stratum9318253stratum
tolan55124013tolan__
tolane64316583tolan_e
tolanes74216313tolanes
tolans64319273tolan_s
volant9316323volan_t
volante1038513volante

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 Limit134027927.00019146.7
3Display Results92920.0303066.7
 (SQL Overall)178691927.42024082.3
 
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.