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

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

156 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
solanins831051(None) 
solanin7311941solanin_
solanine8311531solanine
solanines9310081solanines
alanins7315802_alanins
folacins1337202folacins
melanins10310382melanins
solacing11310132solacing
solands84412342solan_ds
solanos74412852solan_os
solans64122492sola__ns
solanums1044432solanums
solating9315592solating
solations9814622solations
alanin6317273_alanin_
alanine7316863_alanine
alanines8314803_alanines
blains84516373_bla_ins
botanies10312853botanies
coalbins1237083coalbins
cocains111313923coca_ins
colicins12312853colicins
colins85229043col__ins
collins93419833col_lins
colonics123711613colonics
colonies103620013colonies
conins84327233co__nins
cyanins122910013_cyanins
dolphins1445653dolphins
domains10510873doma_ins
elains64919853_ela_ins
flavins1338543_flavins
folacin1238053folacin_
gelatins93414093gelatins
guanins8810013_guanins
isolating1039743isolating
isolations10310693isolations
jalapins1745623jalapins
lapins84520683__lapins
layins93817653__layins
linins65922143__linins
loaning83614833lo_aning
loanings9348013lo_anings
melanics1237733melanics
melanin9310893melanin_
moaning103714443mo_aning
olefins1037493_olefins
oleins6313523_ol_eins
paladins11911003paladins
plains85019593_pla_ins
planing103418253_planing
polarons1039863polarons
prolamins13159703prolamins
relaxins15248683relaxins
sabins85521983s__abins
safranins1244353safranins
sains55639973s__a_ins
salamis9313513salami_s
salaries8319573salaries
salicins10310933salicins
sanies63031953s__anies
saning75127643s__aning
saponins1039453saponins
sarins63932623s__arins
sasins64923103s__asins
satins64930483s__atins
savarins1139893savarins
savins93923133s__avins
siganids1045303siganids
silanes72517163silan_es
slain54923573s_la_in_
slaking123717473s_laking
slanging103413433s_langing
slangs75615343s_lan_gs
slanting94115093s_lanting
slants64819083s_lan_ts
slating83724653s_lating
slatings94011723s_latings
slaving113514833s_laving
slaying113316843s_laying
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
soarings93210393so_arings
solacers10268893solacers
solaces93116133sola_ces
solan55328153sola__n_
soland75115043sola__nd
solander948123solander
solanders1036963solanders
solano65314183sola__no
solanum946403solan_um
solaria7312493solari_a
solarise8512543solarise
solarises9512703solarises
solarism10810383solarism
solarisms1168813solarisms
solarium1078263solarium
solariums1165923solariums
solarize17511473solarize
solarizes18511613solarizes
solates73523853sola_tes
solatia7312253solati_a
solation8916153solation
solatium1067613solatium
soldans83210403sol_dans
soleness8814263soleness
solenoids1045543solenoids
solicits10311023solicits
solids74116403sol__ids
soling74226823sol__ing
solions7513753sol_ions
solitons849593solitons
soloing82813803sol_oing
solonets838233solonets
solons65120023sol__ons
solutions988883solutions
solvating1336443solvating
solvations1336833solvations
solving112910853sol_ving
somans84619303soma__ns
sonances10310263sonances
sonants7511233sonan_ts
sonatina849073sonatina
sonatinas945683sonatinas
sonatine8313323sonatine
sonics84315633so__nics
sonnies7315223so_nnies
sopranino1143913sopranino
sopraninos1251983sopraninos
sorning83116813so_rning
souaris7312333souari_s
sowans94215893sowa__ns
sozins15510793so__zins
spavins12419323s_pavins
speaning113512243speaning
splaying14219303splaying
splenius1046033splenius
splining11310773splining
sprains93013593spra_ins
stains64923653s_ta_ins
stanine73417073s_tanine
stanines85115673s_tanines
staning83922243s_taning
statins73719773s_tatins
stearins8312143stearins
strains74218153stra_ins
swains94513953s_wa_ins
sylvins13246243syl_vins
synanons1144633synanons
tolanes74216313tolan_es
tolans64319273tola__ns
tolidins948023tolidins
volcanics1643653volcanics
volutins1188003volutins
womaning1437643womaning

Search took 10 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621568.86016496.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911569.34319125.7
 
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.