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

168 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
luminal9371100(None) 
laminal94113631laminal
liminal93810671liminal
lumenal9307271lumenal
lumina84613541lumina_
ruminal9289991ruminal
alumina9510052alumina_
aluminas1048352aluminas
geminal10109912geminal
lamina84920442lamina_
laminae93512972laminae
laminals10339302laminals
laminar93810282laminar
laminas93615872laminas
limina83514502limina_
luminary13336652luminary
nominal92712372nominal
numina83510842numina_
rumina83412482rumina_
seminal91213412seminal
urinal6614122_urinal
viminal12288822viminal
actinal9312293actinal
admiral1046363admiral
affinal1336443affinal
albinal937813albinal
alumin8513543alumin__
aluminate1149373aluminate
alumine9412693alumin_e
alumines10411683alumines
aluminic1245773aluminic
alumins9512983alumin_s
aluminum1274563aluminum
alumna857343alum_na_
alumnae955403alum_nae
ammonal1137023ammonal
anginal8310163anginal
audial7312993audi_al
basinal9310033basinal
binal75323823__binal
bluming123511283blumin_g
burial84117623buri_al
cacuminal1553473cacuminal
carinal94318233carinal
clinal8311553_clinal
columnal1244413colum_nal
comical13312223comical
criminal1248303criminal
cubical1338463cubical
cubital1137103cubital
cumin94616973cumin__
cumins103314933cumin_s
curial84019153curi_al
domical1239373domical
eluvial1045853eluvi_al
encinal949243encinal
final83922033__final
fluidal1144653flu_idal
fluming133512793flumin_g
fluvial1345363fluvi_al
fluxional1952403fluxional
fuming124013293fumin_g
fumingly1735743fumingly
fusional1145073fusional
germinal1147263germinal
humeral1238563humeral
humoral1237973humoral
hymenal1545183hymenal
hymnal1434913hym_nal
jumbal1758463jum_bal
juvenal1743393juvenal
labial84714343labi_al
lacunal9136553lacunal
laical8312323l_aical
lamia75324323lami_a_
lamiae84817453lami_ae
lamias85020613lami_as
laminable1337123laminable
laminary13337253laminary
laminate103014633laminate
laming94528363lamin_g
laminin939973laminin
lanital7310913lanital
latina65621143latina_
latinas74416463latinas
lexical1637363lexical
lienal63912783l_ienal
liming94021243limin_g
linac7315413l__inac
lineal65616023l__ineal
logical1038513logical
lubing94114043lubin_g
lubrical12116093lubrical
luging83915293lugin_g
luma65527523lum__a_
lumas75622913lum__as
lumbar103610593lum_bar
lumbrical15113383lumbrical
lumen75220903lumen__
lumens85013973lumen_s
luminaire1143933luminaire
luminance1345163luminance
luminaria1144773luminaria
luminism1247353luminism
luminist10410563luminist
luminous1037113luminous
lumping123314643lumpin_g
lumpingly1784663lumpingly
luna46229853lu__na_
lunar57017313lu__nar
lunas55025013lu__nas
lupanar963283lupanar
lupin75215843lupin__
lupine84013533lupin_e
lupines93912503lupines
lupins84514463lupin_s
luring73820753lurin_g
luringly1237323luringly
lustral7339653lustral
luteal64411483lu_teal
luting75221753lutin_g
lutings83311053lutings
lyrical1236493lyrical
matinal9312603matinal
mimical1339233mimical
mina65136923__mina_
minae75627723__minae
minas75434113__minas
musical1139553musical
nomina83113683nomina_
nominals10278613nominals
noumenal1046173noumenal
numeral939083numeral
ordinal838633ordinal
paginal10269493paginal
pluming123412043plumin_g
pluvial1245433pluvi_al
quinol15357973qu_inol
quintal16389883qu_intal
reginal84814293reginal
retinal75318353retinal
rhinal9510193_rhinal
ruminant1047863ruminant
ruminate10511473ruminate
semina8915573semina_
seminar979763seminar
somital939403somital
spinal84915313_spinal
staminal1046983staminal
summital1244703summital
tegminal1144453tegminal
terminal1039733terminal
trinal6516963_trinal
tumoral938133tumoral
turbinal1045623turbinal
umbonal1144383_umbonal
umbral1038633_umbral
umiac938963_umi_ac
umiak1137673_umi_ak
umiaq1656823_umi_aq
uncinal959963uncinal
urial54823023_uri_al
urinals7610253_urinals
vaginal11288403vaginal
veinal93812963_veinal
vicinal12268543vicinal
vimina11339943vimina_
vinal85725813__vinal

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.453394461.4
2DLD Change Limit1340271685.85622887.1
3Display Results1681680.0632666.7
 (SQL Overall)1786911686.37228043.2
 
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.