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 “solanine” 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.

155 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
solanine831153(None) 
solanin7311941solanin_
solanines9310081solanines
solanins8310511solanins
alanine7316862_alanine
solacing11310132solacing
solarise8512542solarise
solarize17511472solarize
solating9315592solating
sonatine8313322sonatine
stanine73417072s_tanine
alanin6317273_alanin_
alanines8314803_alanines
alanins7315803_alanins
allanite8411093allanite
botanise1039643botanise
botanize1948753botanize
calamine12314033calamine
canine83826703__canine
celandine1245623celandine
cocaine111315173coca_ine
colicine12312993colicine
colonise102514283colonise
colonize192312773colonize
conine84528553co__nine
cotinine10311493cotinine
cyanine122911513_cyanine
delaine8314793dela_ine
domaine10610503doma_ine
dopamine1346173dopamine
eglantine1044973eglantine
elapine9310673_elapine
flavine1338453_flavine
folacin1238053folacin_
folacins1337203folacins
galantine1047333galantine
gelatine93213313gelatine
guanine8810543_guanine
hominine1348913hominine
isolating1039743isolating
isoline7314013isol__ine
larine63927043__larine
lawine93316463__lawine
loaning83614833lo_aning
melamine12310303melamine
melanin9310893melanin_
melanins10310383melanins
melanite10512033melanite
melanize19410303melanize
moaning103714443mo_aning
moline84422033mol__ine
moraine9314573mora_ine
olefine1038023_olefine
oleine6313793_ol_eine
olivine1038843_olivine
opaline9412483_opaline
oscinine1045533oscinine
oxazine2354773_oxazine
palatine10316073palatine
planing103418253_planing
polarise10513903polarise
polarize19512653polarize
polyamine1647213polyamine
prolamine131510563prolamine
rolamite1048743rolamite
romaine9512123roma_ine
romanise10312133romanise
romanize19311013romanize
sabine84020393s__abine
safranine1244803safranine
salicine10311703salicine
saline65132703s__aline
salinize1739683salinize
saltine75018563sal_tine
saning75127643s__aning
saponine1039223saponine
savine94220283s__avine
selenide9158873selenide
selenite81713113selenite
sepaline10311343sepaline
silane62718053sila__ne
silkaline1344243silkaline
simazine1945363simazine
slain54923573s_la_in_
slainte738543s_lainte
slaking123717473s_laking
slanging103413433s_langing
slanting94115093s_lanting
slating83724653s_lating
slaving113514833s_laving
slaying113316843s_laying
sloganize1944593sloganize
smaltine1037833smaltine
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
sodalite9109593sodalite
sodamide1245453sodamide
solace83415823sola__ce
solan55328153sola__n_
soland75115043sola__nd
solander948123solander
solands84412343solan_ds
solano65314183sola__no
solanos74412853solan_os
solans64122493sola__ns
solanum946403solan_um
solanums1044433solanums
solaria7312493solari_a
solarised1068043solarised
solarises9512703solarises
solarism10810383solarism
solarium1078263solarium
solarized1969153solarized
solarizes18511613solarizes
solate64526073sola__te
solatia7312253solati_a
solation8916153solation
solations9814623solations
solatium1067613solatium
solecise1089073solecise
solecize1998383solecize
solemnize2044933solemnize
soling74226823sol__ing
soloing82813803sol_oing
solstice1047223solstice
solvating1336443solvating
solving112910853sol_ving
sonance9310313sonan_ce
sonatina849073sonatina
sopranino1143913sopranino
sordine82515233so_rdine
soricine10710883soricine
sorning83116813so_rning
sourdine936893sourdine
sozine15712353so__zine
speaning113512243speaning
splaying14219303splaying
spline86020533spl__ine
splining11310773splining
stanines85115673s_tanines
staning83922243s_taning
stearine8311903stearine
sycamine1545723sycamine
sylvanite1543793sylvanite
sylvine13216543syl_vine
tolane64316583tola__ne
tolidine948193tolidine
topazine1944983topazine
volante1038513volan_te
volatile1146433volatile
volcanize2345733volcanize
womaning1437643womaning
womanise1348733womanise
womanize2248163womanize

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621557.12320519.7
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.60923484.2
 
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.