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

180 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
solanin731194(None) 
solanine8311531solanine
solanins8310511solanins
alanin6317272_alanin
folacin1238052folacin
melanin9310892melanin
slain54923572s_la_in
solacing11310132solacing
solan55328152sola__n
soland75115042solan_d
solands84412342solands
solanines9310082solanines
solano65314182solan_o
solanos74412852solanos
solans64122492solan_s
solanum946402solanum
solaria7312492solaria
solatia7312252solatia
solating9315592solating
solation8916152solation
alanine7316863_alanine
alanins7315803_alanins
blain75421793_bla_in
botanic1159583botanic
coalbin1137533coalbin
cocain101315013coca_in
colicin11313743colicin
colin76231693col__in
coloni85619203coloni_
colonic115015713colonic
conin76232723co__nin
cyanin113911453_cyanin
dolphin1345533dolphin
domain9511323doma_in
elain55324703_ela_in
flavin1239303_flavin
folacins1337203folacins
gelatin83514733gelatin
guanin7610803_guanin
isolating1039743isolating
isolation9311643isolation
jalapin1645923jalapin
lain46146283__la_in
lapin75222923__lapin
layin84720333__layin
linin58025523__linin
loaning83614833lo_aning
logania847833logania
melanian1048483melanian
melanic11310403melanic
melanins10310383melanins
moaning103714443mo_aning
olefin937583_olefin
olein5316003_ol_ein
paladin101011773paladin
plain74823303_pla_in
planing103418253_planing
polaron939843polaron
prolamin12139753prolamin
relaxin14239183relaxin
sabin74924953s__abin
safranin1145213safranin
sain45551293s__a_in
salami8313103salami_
salamis9313513salamis
salicin9311223salicin
saning75127643s__aning
saponin9310263saponin
sarin55239253s__arin
sasin54626573s__asin
satanic939933satanic
satin55935223s__atin
savarin10310003savarin
savin84625083s__avin
selenic9410663selenic
siganid947203siganid
silane62718053silan_e
silanes72517163silanes
sileni63312143sileni_
slaking123717473s_laking
slang66324023s_lan_g
slanging103413433s_langing
slangs75615343s_langs
slangy105411393s_langy
slank95822773s_lan_k
slant55238703s_lan_t
slanting94115093s_lanting
slants64819083s_lants
slanty95114843s_lanty
slating83724653s_lating
slaving113514833s_laving
slaying113316843s_laying
soaking123116613so_aking
soaping103616223so_aping
soaring83521893so_aring
sola45541863sola___
solace83415823sola_ce
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solander948123solander
solanums1044433solanums
solar55927343sola__r
solarise8512543solarise
solarism10810383solarism
solarium1078263solarium
solarize17511473solarize
solate64526073sola_te
solated83618023solated
solates73523853solates
solations9814623solations
solatium1067613solatium
soldan73511853sol_dan
soldans83210403soldan_s
soldi65717203sol_di_
solei55624343sol_ei_
solemn838643sol_emn
solenoid947873solenoid
soli46637013sol__i_
solicit9315743solicit
solid65025083sol__id
solidi73813153solidi_
soling74226823solin_g
solion6616383sol_ion
soliton7410233soliton
soloing82813803soloing
solon55026133sol__on
solons65120023solon_s
solunar735283solunar
solution889593solution
solvating1336443solvating
solvation1237773solvation
solving112910853solving
soman75024903soma__n
somans84619303soman_s
somatic111916463somatic
somoni8310743somoni_
sonance9310313sonance
sonant6621953sonan_t
sonantic1048273sonantic
sonants7511233sonants
sonatina849073sonatina
sonatine8313323sonatine
sonic75225293so__nic
soprani937403soprani_
sopranino1143913sopranino
sorning83116813so_rning
souari6311383souari_
souaris7312333souaris
sowans94215893sowan_s
sozin14514543so__zin
spavin114210653s_pavin
speaning113512243speaning
splaying14219303splaying
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splining11310773splining
sprain83614863spra_in
stain55727943s_ta_in
stanine73417073s_tanine
staning83922243s_taning
statin63921473s_tatin
stearin7312003stearin
stolonic1047583stolonic
strain64919573stra_in
sultanic1046173sultanic
swain84919053s_wa_in
sylvin12247303syl_vin
synanon1044743synanon
tolan55124013tola__n
tolane64316583tolan_e
tolanes74216313tolanes
tolans64319273tolan_s
tolidin839243tolidin
volant9316323volan_t
volante1038513volante
volcanic1544773volcanic
volutin1098103volutin
womaning1437643womaning

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.406440125.6
2DLD Change Limit1340271806.90619407.3
3Display Results1801800.0762368.4
 (SQL Overall)1786911807.38824186.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.