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 “solum” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
solum7471760(None) 
slum65430511s_lum
solums85211331solums
solus54726981solus
alum65227612_alum
asylum1144892asylum
bolus79125542bolus
column1038102column
doum76226672do_um
filum105015432filum
folium11310452folium
forum108318762forum
glum75825102_glum
golem8416112golem
hilum105514602hilum
hokum1436762hokum
holm95628102hol_m
jorum145513742jorum
locum94812172locum
lum55542932__lum
notum7611682notum
oleum73613322_oleum
ovum92310172_ovum
plum85122102_plum
sagum8512872sagum
scrum95418192scrum
scum85924522s_cum
sebum93814552sebum
sedum84115572sedum
serum75223472serum
shlub105411742shlub
shlump1345712shlump
sholom11910092sholom
siglum936562siglum
slam67737972s_lam
slim66631952s_lim
slub65428032s_lub
slue45332192s_lue
slug55124642s_lug
slump94816632s_lump
slums74623432s_lums
slur45525152s_lur
slut45040592s_lut
sodium92111442sodium
sodom8814902sodom
sol37256622sol__
sola45541862sol_a
solan55328152solan
solanum946402solanum
solar55927342solar
sold54837412sol_d
soldi65717192soldi
soldo67116562soldo
sole46053672sol_e
soled65835172soled
solei55624332solei
solemn838642solemn
soles55547922soles
soleus64615612soleus
soli46637002sol_i
solid65025072solid
solo45538942sol_o
solon55026132solon
solos54830792solos
sols45448162sol_s
solute64016662solute
solve85618942solve
som59153802so__m
sorus54527582sorus
sou37853692so_u_
souk86127172so_uk
soul46435712so_ul
souls55127362souls
soup66232912so_up
sour45935892so_ur
sous46947212so_us
soyuz1748852soyuz
strum75619442strum
stum65526012s_tum
sulu45128422sulu_
sulus54821882sulus
sum56346012s__um
swum96416822s_wum
tolu45529152tolu_
tolus55024482tolus
velum10713382velum
volume11358272volume

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit53800873.68614595.8
3Display Results87870.0461891.3
 (SQL Overall)178691873.82546716.6
 
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.