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

141 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
lexical163736(None) 
lexica1536101lexica_
clerical1248232clerical
epical10413392_epical
helical12311152helical
laical8312322l_aical
lexically2146772lexically
lexicon1643902lexicon
logical1038512logical
lyrical1236492lyrical
medical12312512medical
metical11315362metical
toxical1637642toxical
vesical12159812vesical
aecial84817313aeci_al
aerial64625713aeri_al
alexia132910463alexi_a_
alexias14249793alexi_as
alogical1147763alogical
apical10913903_apical
axial124515193_axi_al
cecal94619113ce__cal
cercal10314123ce_rcal
cervical1546853cervical
chemical1748393chemical
clericals1345353clericals
clinical1247023clinical
comical13312223comical
conical11316203conical
cubical1338463cubical
cynical1437873cynical
decal85523233de__cal
decimal1238083decimal
deifical1445543deifical
denial74720513deni_al
devisal1136913devisal
dextral1577003dextral
domical1239373domical
edictal1046993_edictal
elegiacal1252133elegiacal
erica7316543_erica_
ericas8315463_ericas
ethical1238443ethical
excel1437743_ex_cel
fecal105119213fe__cal
fecial114714623feci_al
ferial94621253feri_al
fetial95716193feti_al
finical1239693finical
flexional1942473flexional
flexural1842443flexural
galenical1244683galenical
geminal10109913geminal
genial74917613geni_al
genital849793genital
geoidal936713geoidal
gestical1138993gestical
hectical1547933hectical
heliacal1344723heliacal
heroical13410023heroical
indexical1944453indexical
irenical1048553irenical
labial84714343labi_al
laminal94113633laminal
lanital7310913lanital
leal46043273le___al
legal65715943le__gal
lemniscal1342273lemniscal
lenticel1066123lenticel
lethal939803le_thal
lexicality2254093lexicality
lexicalize2844603lexicalize
lexicons1743893lexicons
lexis125916033lexi__s
liminal93810673liminal
lixivial1842943lixivial
local74820273l__ocal
lorica8310443lorica_
loricae938253loricae
lubrical12116093lubrical
luminal93711003luminal
magical1239783magical
maximal18347093maximal
medial93819863medi_al
medicals1349363medicals
menial84223033meni_al
meniscal1246203meniscal
mescal104113493me_scal
mesial84818083mesi_al
meticals12310763meticals
metrical12311593metrical
mezcal19367853me_zcal
mimical1339233mimical
musical1139553musical
nodical1049863nodical
nonlexical1945213nonlexical
oedipal1045173oedipal
optical1149863optical
pedicab1446693pedicab
pedicel1237813pedicel
pedocal1237893pedocal
pelican1139433pelican
pemican1348163pemican
penial84120893peni_al
penicil1138833penicil
pical95524373__pical
plexal1536843plex__al
plical10411683_plical
poetical12311533poetical
polemical1547343polemical
radical103312793radical
recital9412163recital
redial74923113redi_al
reginal84814293reginal
retial64724993reti_al
retinal75318353retinal
revisal1038263revisal
revival1337033revival
scenical1247133scenical
seminal91213413seminal
septical1259363septical
serial64625863seri_al
sexual1338413sex_ual
sterical10311253sterical
stoical9310283stoical
taxicab1843413taxicab
telial65815363teli_al
textual1444603textual
thetical1349123thetical
tical76021493__tical
topical1139953topical
typical1436343typical
vatical1239983vatical
veinal93812963ve_inal
venial94218283veni_al
vertical13410433vertical
vesica11157913vesica_
vesicae12177703vesicae
vexil1538963vexi__l
vexilla1744663vexilla
xenial133414903xeni_al

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 Limit1340271415.95322514.2
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.40527898.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.