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

147 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
salicine1031170(None) 
salicin9311221salicin_
salicines11310001salicines
salicins10310931salicins
calcine11315272cal_cine
calycine1546962calycine
colicine12312992colicine
culicine1248342culicine
saline65132702sal__ine
salinize1739682salinize
saltine75018562sal_tine
sanidine939852sanidine
silicide1147832silicide
silicone1096732silicone
slicing103514642s_licing
soricine10710882soricine
splicing1338962splicing
alanine7316863_alanine
alcidine1148233_alcidine
alexine142410543_alexine
algicide1245563_algicide
aline57243153_al__ine
alining81917043_alining
alkine104916803_al_kine
allicin949953allicin_
allicins1049653allicins
alpine84417373_al_pine
alumine9412693_alumine
alvine94614583_al_vine
amidine103613853_amidine
aniline7418473_aniline
asinine7310723_asinine
balkline1437973balkline
calamine12314033calamine
calcimine1565413calcimine
calcined1338743cal_cined
calcines12314753cal_cines
calcite11413783cal_cite
caliche14329963calic_he
calicle113111433calic_le
colicin11313743colicin_
colicines13311203colicines
colicins12312853colicins
culicines1347013culicines
fascine12510583fa_scine
filicide1446363filicide
gallicize2164993gallicize
glycine1335713_glycine
halocline1445343halocline
helicline1444693helicline
italicise1173983italicise
italicize2054043italicize
laicise939333la_icise
laicize1838093la_icize
malice104818483malic__e
malihini1344823malihini
maline84529083mal__ine
medicine1349543medicine
olivine1038843_olivine
palatine10316073palatine
policing13311673policing
pulicene1245723pulicene
pulicide1347043pulicide
ralline73518413ral_line
raticide1148943raticide
sabine84020393sa__bine
saice75424053sa_ic__e
sailing83927373sa_iling
saimin8313663sa_imin_
saimins9312113sa_imins
saining83621393sa_ining
salacity1347853salacity
salic73424713salic___
salience10117903salience
salient7419763sali_ent
salified12310363salified
salifies11314793salifies
salifying1636333salifying
salina64221123sal__ina
salines74029413sal__ines
salinity1138893salinity
salinized1947383salinized
salinizes1839153salinizes
salivate11310013salivate
sallying12309853sallying
salpinx1636093sal_pinx
saltie63422433sal_ti_e
saltines82917793sal_tines
salting84120793sal_ting
saltire73113043sal_tire
saltlike1237253saltlike
saluting9310553saluting
salving113913153sal_ving
salvoing1236423salvoing
sanguine947633sanguine
sanicle91210263sanic_le
sanidines1048043sanidines
sanitise81511813sanitise
sanitize171410083sanitize
saponine1039223saponine
sarcina9310733sa_rcina
sarcinae1047193sa_rcinae
sardine83317393sa_rdine
satirise8310683satirise
satirize1749703satirize
saucing10311003sa_ucing
savine94220283sa__vine
sericin9312843sericin_
sericins10312463sericins
silicate10312623silicate
silicic1147603silici_c
silicides1247073silicides
silicify1644273silicify
silicium1286563silicium
silicle937753silic_le
silicon9117533silicon_
silicones11106553silicones
silicons10107163silicons
sinicize1947333sinicize
slice74925823s_lic__e
slicken13309293s_licken
slicking153712593s_licking
sliding93114553s_liding
sliming102913953s_liming
sliping103314413s_liping
sluicing1137063sluicing
smaltine1037833smal_tine
solacing11310133solacing
solanine8311533solanine
solecise1089073solecise
solecize1998383solecize
solicit9315743solici_t
solicited1247973solicited
solicits10311023solicits
spicing123914533s_picing
splice104915103splic__e
spline86020533spl__ine
splining11310773splining
stibine938663s_tibine
suicide1038893s_uicide
sylvine13216543syl_vine
talcing103111633tal_cing
tolidine948193tolidine
vaccine1437323va_ccine
valine94623093val__ine
vaticide1446863vaticide
xylidine1943753xylidine

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 Limit1461621476.70321805.5
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.18624866.5
 
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.