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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
solans6412249(None) 
solan55328151solan_
soland75115041soland
solands84412341solands
solano65314181solano
solanos74412851solanos
soldans83210401soldans
solons65120021solons
somans84619301somans
sowans94215891sowans
tolans64319271tolans
alans55636172_alans
bogans95714812bogans
bolas74733762bola_s
clans75031012_clans
colas75436772cola_s
colins85229042colins
colons86028682colons
cotans81317922cotans
dolmans10479682dolmans
elans55527752_elans
flans85327972_flans
glans65125832_glans
gobans94412042gobans
gowans105512292gowans
hogans105914312hogans
honans94814502honans
koans95818622ko_ans
kolas94822232kola_s
loans56026462lo_ans
logans76319062logans
lorans65117602lorans
moans74624372mo_ans
molars85517322molars
molas75132092mola_s
plans75731272_plans
polars84419352polars
prolans9314272prolans
roans54926442ro_ans
romans84620242romans
rowans95715342rowans
salads75316962salads
salals65120082salals
salons63823692salons
sans45153362s__ans
sarans64224432sarans
scans74625102s_cans
sedans74816092sedans
selahs9313212selahs
sewans95215902sewans
shorans102812412shorans
silane62718052silane
silanes72517162silanes
silvans10308332silvans
skeans104512912skeans
slabs75322642s_labs
slags66525902s_lags
slams74927902s_lams
slang66324022s_lang
slangs75615342s_langs
slank95822772s_lank
slant55238702s_lant
slants64819082s_lants
slaps76025712s_laps
slats55436902s_lats
slaws85222712s_laws
slays85723682s_lays
slogans8407982slogans
soaks95220292so_aks
soaps75120712so_aps
soars54732512so_ars
sobas74424252soba_s
socas74026182soca_s
sodas64123542soda_s
sofars94712782sofars
sofas85320712sofa_s
sojas124716392soja_s
sola45541862sola__
solace83415822solace
solaces93116132solaces
solanin7311942solanin
solanins8310512solanins
solanum946402solanum
solanums1044432solanums
solar55927342sola_r
solate64526072solate
solates73523852solates
soldan73511852soldan_
soles55547922sol_es
soleus64615612soleus
solids74116402solids
soling74226822soling
solions7513752solions
solon55026132solon_
solos54830792sol_os
sols45448162sol__s
solums85211332solums
solus54726982sol_us
solves95018222solves
soman75024902soman_
somas76030372soma_s
sonant6621952sonant
sonants7511232sonants
sonars64818972sonars
sons46049552so__ns
soras55041012sora_s
sorns55028422so_rns
soudans8309352soudans
sovrans1036482sovrans
sowars94318012sowars
sowens93613152sowens
soyas84520912soya_s
sozins15510792sozins
spans74528732s_pans
speans85417142speans
splats84817302splats
splays114910872splays
stolons73410242stolons
suldans8299722suldans
sultans72411832sultans
swans84625012s_wans
sylvans13235892sylvans
tolan55124012tolan_
tolane64316582tolane
tolanes74216312tolanes
tolars64817942tolars
tolas54532772tola_s
tomans85419132tomans
uhlans937572uhlans
ulans54921302_ulans
volant9316322volant
womans114613652womans
xylans1635882xylans
yulans958672yulans

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 Filter178691825510.373479064.3
2DLD Change Limit825511342.81329346.2
3Display Results1341340.0462913.0
 (SQL Overall)1786911343.23255288.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.