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

152 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
vicinal1226854(None) 
viminal12288821viminal
encinal949242encinal
liminal93810672liminal
ovicidal1443922ovicidal
piscinal1285842piscinal
uncinal959962uncinal
vaccinal1544902vaccinal
vaginal11288402vaginal
vaticinal1444572vaticinal
veinal93812962v_einal
vicinage1444002vicinage
vicing124014242vicin_g
victual1246252victual
vicuna11115902vicuna_
vicunas1285612vicunas
vimina11339942vimina_
vinal85725812v__inal
virginal1244572virginal
visional1146662visional
acinar8310483_acinar
actinal9312293actinal
aecial84817313aeci_al
affinal1336443affinal
albinal937813albinal
anconal939423anconal
anginal8310163anginal
basinal9310033basinal
binal75323823__binal
biocidal1344943biocidal
bivinyl1542733bivinyl
bizonal1845563bizonal
canal75428043__canal
carinal94318243carinal
clinal8311553_clinal
criminal1248303criminal
decanal1038113decanal
decimal1238083decimal
deicidal1245713deicidal
diaconal1196133diaconal
dicing105718763dicin_g
dictional1268613dictional
digital937063digital
diurnal844883diurnal
encina8310443encina_
encinas938723encinas
facial113615633faci_al
fecial114714623feci_al
ficin103516723ficin__
ficins113513983ficin_s
fictional1477803fictional
filial93013253fili_al
final83922033__final
finial92814183fini_al
finical1239693finical
geminal10109913geminal
icing86017753_icin_g
icings9428453_icings
ilial55317843_ili_al
incisal947373incisal
lacunal9136553lacunal
laminal94113633laminal
lienal63912783li_enal
limina83514503limina_
luminal93711003luminal
matinal9312603matinal
medicinal1445083medicinal
mimical1339233mimical
minimal114010603minimal
nitinol745143nitinol
nominal92712373nominal
officinal1743543officinal
orcinol944703orcinol
ordinal838643ordinal
original956793original
paginal10269493paginal
pical95524373pic__al
pinnal84814273pi_nnal
piscina1177043piscina_
piscinae1285213piscinae
piscinas1275483piscinas
racial83419243raci_al
recital9412163recital
reginal84814293reginal
retinal75318353retinal
rhinal9510193_rhinal
ricin74620213ricin__
ricing94822763ricin_g
ricins83618703ricin_s
ricinus9408123ricinus
rictal83113183ric_tal
ruminal9289993ruminal
seconal9310073seconal
seminal91213413seminal
signal73711483si_gnal
social8813333soci_al
spinal84915313_spinal
suicidal1146073suicidal
tibial849843tibi_al
tical76021493tic__al
trichinal1445663trichinal
trinal6516963_trinal
uncial83715223unci_al
urinal6614123_urinal
vaccina1435303vaccina_
vaccinas1544973vaccinas
vaccinial1643133vaccinial
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
vatical1239983vatical
venal85523213v__enal
venial94218283veni_al
vernal93514213v_ernal
vesical12159813vesical
vial76731093v__i_al
viatical1347063viatical
vicar10513863vic__ar
vicarial1347793vicarial
vicenary1654973vicenary
vicennial1443463vicennial
vicinages1544073vicinages
vicinity1645813vicinity
vicious1239493vicious
victuals1344773victuals
vicugna1342083vicugna_
vicugnas1442043vicugnas
vigia94813273vigi_a_
vigias104110893vigi_as
vigil94313003vigi__l
viking143414613vikin_g
vikings15386623vikings
vina76331803v__ina_
vinals94716483v__inals
vinas85126343v__inas
vineal94814743vi_neal
vining104619463vinin_g
vinyl115311623v__inyl
viral86419593v__iral
virginals1343213virginals
viricidal1543843viricidal
virtual1045913virtual
virucidal1552453virucidal
visceral1344673visceral
viscoidal1543173viscoidal
vising103915873visin_g
visual938803vi_sual
vital84819673v__ital
vizirial2043473vizirial
vocal104715643voc__al
voicing13279083voicin_g
voicings14274613voicings

Search took 7 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 Limit1340271526.36021073.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.82926166.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.