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

185 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
savarins113989(None) 
savarin10310001savarin_
safaris101110662safari_s
salaries8319582salaries
sarins63932622s__arins
savaging1356672savaging
savins93923132sav__ins
savories11311272savories
savoring1269482savoring
stearins8312142stearins
tamarins10310842tamarins
acarids105312243_acarids
acarine9316003_acarine
acarines10314343_acarines
agarics10319943_agarics
alanins7315803_alanins
aldrins8310203_aldrins
ascarids11438503ascarids
ascaris93613323ascari_s
aspirins1037733aspirins
avails939693_ava_ils
avarice1238033_avarice
avarices1337183_avarices
aviaries1139783_aviaries
avidins11349003_avidins
calvarias1447663calvarias
calvaries1449803calvaries
canakins142010463canakins
canaries10318943canaries
carabins12312363carabins
cavalries1446363cavalries
cavatina1347333cavatina
cavatinas1444783cavatinas
cavatine13310323cavatine
caverns124510253caver_ns
covaries13413253covaries
cumarins1238643cumarins
dataries9314033dataries
favoring1596673favoring
gastrins9310123gastrins
havartis1444373havartis
havering152211053havering
heparins13310123heparins
jalapins1745623jalapins
javelins18277733javelins
lavations1238973lavations
malarias10313773malarias
manakins14209763manakins
mandarins12410393mandarins
margarins1248293margarins
mavins115119183mav__ins
navaids1134803nava_ids
navars92810573navar__s
ovaries10312653_ovaries
paladins11911003paladins
papains11312363papa_ins
pavans115715593pava__ns
pavins114919663pav__ins
ravaging1346323ravaging
ravelins113011603ravelins
ravins94622563rav__ins
sabatons1037843sabatons
sabayons1343963sabayons
sabering112113743sabering
sabins85521983s__abins
sabring102614843sa_bring
sacatons1038973sacatons
saccharins1744763saccharins
sacring103115983sa_cring
sacrings11278923sa_crings
sadirons936023sadirons
safari91110223safari__
safaried1236253safaried
safariing1344553safariing
saffrons1444303saffrons
safranins1244353safranins
saggaring12236243saggaring
saimins9312113sa_imins
sains55639973s__a_ins
salamis9313513salami_s
salariat8416303salariat
salariats947823salariats
salaried9311023salaried
salarying1336073salarying
salicins10310933salicins
salvaging1465283salvaging
salvarsans1351953salvarsans
salvations1338133salvations
samaras9312913samar_as
samaritans1242933samaritans
samarium1257283samarium
samariums1345133samariums
sangrias938373sangrias
saponins1039453saponins
sarans64224433s__arans
sarin55239253s__arin_
saris54544953s__ari_s
sasins64923103s__asins
sataras7315063satar_as
satins64930483s__atins
satoris7317253satori_s
satyrids1245623satyrids
saurians837763sa_urians
sauries72821623sa_uries
savageries1444253savageries
savages1139973sava_ges
savagism1444883savagism
savagisms1544063savagisms
savanna1043713sava_nna
savannas1143733savannas
savant9416043sava__nt
savants1038653sava_nts
savates10312953sava_tes
savers93825923saver__s
savin84625083sav__in_
savine94220283sav__ine
savines104417633sav__ines
saving104724513sav__ing
savings114412953sav__ings
savorers1157223savorers
savorier1136643savorier
savoriest1246623savoriest
savorily1445043savorily
savoriness1354933savoriness
savorous1146603savorous
savors95616103savor__s
savouries1245473savouries
savouring1335193savouring
savvies1337603sav_vies
savvying1862723savvying
scaring103421973s_caring
seafaring1345963seafaring
seafarings1442783seafarings
searing83330923s_earing
seatrains947603seatrains
senarius8310103senarius
serins64029673s__erins
severing122013853severing
shairns10276783s_hairns
sharias102516003s_harias
sharifs13279903s_harifs
sharing113723243s_haring
sharns95516983s_har_ns
shearing123915903shearing
shearings13337563shearings
slaveries1249693slaveries
slavering1338723slavering
smearing113511753smearing
snaring83920953s_naring
soaring83521893s_oaring
soarings93210393s_oarings
solanins8310513solanins
souaris7312333souari_s
sovrans1036483sov_rans
sparids103512123s_parids
sparing104823873s_paring
spavins12419323s_pavins
spearing113216103spearing
sprains93013593spra_ins
squaring18158633squaring
stains64923653s_ta_ins
staring84527053s_taring
statins73719773s_tatins
stearin7312003stearin_
stearine8311903stearine
stearines9311283stearines
strains74218153stra_ins
suberins10315093suberins
sudaries9312753sudaries
sugaring1039053sugaring
swains94513953s_wa_ins
swearing123711443swearing
taborins103310223taborins
tamarin9311923tamarin_
tamarind1147023tamarind
tamarinds1244163tamarinds
tamaris9413603tamari_s
taverns10317803taver_ns
uakaris1146633uakari_s
vagaries12310293vagaries
varias95019903__varias
varies94330873__varies
vivaries1439263vivaries
warfarins1544733warfarins
wavering152410543wavering

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 Limit1461621857.43619656.0
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.93522519.3
 
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.