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 “viminal” 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
viminal1228882(None) 
liminal93810671liminal
vicinal12268541vicinal
vimina11339941vimina_
criminal1248302criminal
geminal10109912geminal
laminal94113632laminal
limina83514502limina_
luminal93711002luminal
mimical1339232mimical
nominal92712372nominal
ruminal9289992ruminal
seminal91213412seminal
vaginal11288402vaginal
veinal93812962v_einal
vinal85725812v__inal
virginal1244572virginal
visional1146662visional
actinal9312293actinal
admiral1046363admiral
affinal1336443affinal
aiming94320843aimin_g
albinal937813albinal
ammonal1137023ammonal
anginal8310163anginal
basinal9310033basinal
bigeminal1443263bigeminal
bimanual1243753bimanual
bimensal1244103bimensal
bimetal1138433bimetal
bimodal1245663bimodal
binal75323823__binal
bivinyl1542733bivinyl
bizonal1845563bizonal
carinal94318233carinal
clinal8311553_clinal
comical13312223comical
criminals1346293criminals
digital937063digital
diurnal844883diurnal
domical1239373domical
encinal949243encinal
filial93013253fili_al
final83922033__final
finial92814183fini_al
finical1239693finical
germinal1147263germinal
gimbal11228813gim_bal
gimmal11247513gim_mal
hymenal1545183hymenal
hymnal1434913hym_nal
ilial55317843_ili_al
imaginal1144903_imaginal
imine75821063_imin_e
imines84918353_imines
imino74315233_imin_o
inimical1247313inimical
jiminy1836273jimin_y
lamina84920443lamina_
laminae93512973laminae
laminals10339303laminals
laminar93810283laminar
laminas93615873laminas
lienal63912783li_enal
liming94021243limin_g
lumenal9307273lumenal
lumina84613543lumina_
matinal9312603matinal
miming114317263mimin_g
mina65136923__mina_
minae75627723__minae
minas75434113__minas
minimal114010603minimal
nitinol745143nitinol
nomina83113683nomina_
nominals10278613nominals
numina83510843numina_
ordinal838633ordinal
original956793original
ovicidal1443923ovicidal
paginal10269493paginal
pinnal84814273pi_nnal
piscinal1285843piscinal
reginal84814293reginal
retinal75318353retinal
rhinal9510193_rhinal
riming93322223rimin_g
rumina83412483rumina_
semina8915573semina_
seminar979763seminar
signal73711483si_gnal
simian8811163simi_an
simians959203simians
similar937853similar
simitar936733simitar
simnel857023sim_nel
somital939403somital
spinal84915313_spinal
staminal1046983staminal
tegminal1144453tegminal
terminal1039733terminal
tibial849843tibi_al
timbal102510753tim_bal
timbral11237193timbral
timing93619303timin_g
timings10279303timings
trinal6516963_trinal
uncinal959963uncinal
urinal6614123_urinal
vaccinal1544903vaccinal
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
vatical1239983vatical
vaticinal1444573vaticinal
venal85523213v__enal
venial94218283veni_al
vernal93514213v_ernal
vesical12159813vesical
vial76731093v__i_al
viatical1347063viatical
vicinage1444003vicinage
vicing124014243vicin_g
victual1246253victual
vicuna11115903vicuna_
vicunas1285613vicunas
vigia94813273vigi_a_
vigias104110893vigi_as
vigil94313003vigi__l
viking143414613vikin_g
vikings15386623vikings
vimen104114753vimen__
vina76331803v__ina_
vinals94716483v__inals
vinas85126343v__inas
vineal94814743vi_neal
vining104619463vinin_g
vinyl115311623v__inyl
viral86419593v__iral
virginals1343203virginals
virtual1045913virtual
vising103915873visin_g
visual938803vi_sual
vital84819673v__ital
vizirial2043473vizirial
vomica1336383vomica_
vomicae1445303vomicae

Search took 10 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 Filter1786911340271.046170832.7
2DLD Change Limit1340271478.76315294.6
3Display Results1471470.0502940.0
 (SQL Overall)1786911479.85918124.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.