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

195 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
lexica153610(None) 
lexical1637361lexical
alexia132910462alexi_a
erica7316542_erica
lexicon1643902lexicon
lexis125916032lexi_s
lorica8310442lorica
vesica11157912vesica
aecia73819283aeci_a
alexias14249793alexias
alexin132311483alexi_n
alexine142410543alexine
alexins141910663alexins
arnica8310443arnica
ceca84820783ce__ca
ceiba938703ce_iba
celiac101910433celiac
ceria75125353ceri_a
ceric94023093ceric_
chica125818263_chica
cleric10612133cleric_
clerical1248233clerical
clerics1149333clerics
deice84320033de_ice
delict94320333delict
demic105119193demic_
depict113514793depict
detick1339383detick
device124512163device
dexie134716893dexi_e
dexies145018343dexies
edict84722283_edict
elegiac1045453elegiac
emic86422753_emic_
epic86921303_epic_
epical10413393_epical
epics95014283_epics
ericas8315463_ericas
etic66123953_etic_
evict104417143_evict
exact143516933_exact
exacta15337393_exacta
exec135313943_exec_
execs14539723_execs
exile126117653_exile
exine125518493_exine
exing136016813_exing
exist124618943_exist
exit114428673_exi_t
exits125515913_exits
exotica16257603_exotica
extra1239003_extra
feria85922713feri_a
fetich1479693fetich
flexile1735073flexile
flexing18358993flexing
flexion1735073flexion
genic85119393genic_
hegira1036523hegira
hejira1644803hejira
heliac111010893heliac
helical12311153helical
hemic125718623hemic_
hexing174210513hexing
ixia115713213_ixi_a
labia75219013labi_a
laic65931563l_aic_
laical8312323l_aical
laich105920713l_aich
laics76419253l_aics
lamia75324323lami_a
lamina84920443lamina
latina65621143latina
laxity1637273laxity
lea37660183le___a
leach105422523le_ach
lech96825443le__ch
leech104913213le_ech
legacy1256653legacy
legion75712983legion
legist71315253legist
legit61323503legi_t
legits71313003legits
lehua837953le_hua
lei36846383le_i__
leis45739603le_i_s
lemma94811033le_mma
lempira1144193lempira
lenis56326863leni_s
lenite6719983lenite
lenity9612713lenity
lentic83515743lentic_
lepta75714393le_pta
lesion64715063lesion
letch105215803le_tch
leucin839113leucin
leva77020713le__va
levied104111433levied
levier94013873levier
levies93919863levies
levin84816413levi_n
levins94514653levins
levis85818553levi_s
levity1277903levity
lewis85315843lewi_s
lex107943823lex___
lexeme1536493lexeme
lexemic1844283lexemic_
lexes127225263lex_es
lexically2146773lexically
lexicons1743893lexicons
lice66045063l__ice
lich96230843l__ich
lick106935073l__ick
lima65734133l__ima
limina83514503limina
lipa68425923l__ipa
lira46928683l__ira
lixivia1743053lixivia
loca65527683l__oca
logia68116603logi_a
logic88217833logic_
logical1038513logical
logics95711123logics
loricae938253loricae
lotic76420673lotic_
loxing143615273loxing
ludic82912803ludic_
luetic8310383luetic_
luetics937323luetics
lumina84613543lumina
lyric104512723lyric_
lyrical1236493lyrical
lyrics11357943lyrics
lytic104513033lytic_
maxima17568633maxima
mecca1139933me_cca
media84721713medi_a
medic104619653medic_
medical12312513medical
medick154010133medick
medico113711163medico
medics114115353medics
medina94114093medina
melic94722333melic_
mesic93617863mesic_
metical11315363metical
mica86428253__mica
modica11310063modica
myrica1336833myrica
oleic7313333ole_ic_
pedicab1446693pedicab
pelican1139433pelican
pemican1348163pemican
pica85831493__pica
plica9613373_plica
redia65524483redi_a
regina75317143regina
relic74623363relic_
relics84517903relics
relict83623903relict
replica1137943replica
retia55326113reti_a
retina65023383retina
rexine134719443rexine
semina8915573semina
seneca839793seneca
sepia75318673sepi_a
sepic94617053sepic_
sexier13310683sexier
sexily1638853sexily
sexing144313893sexing
sexism15227653sexism
sexist133013483sexist
silica8311243silica
spica94717943_spica
taxicab1843413taxicab
telia55821143teli_a
telic76019823telic_
tenia55324483teni_a
toxic145315623toxic_
toxical1637643toxical
toxics153910203toxics
tunica8379813tunica
ulexite1445723ulexite
vesicae12177703vesicae
vesical12159813vesical
vexil1538963vexi_l
vexilla1744663vexilla
vexils1647173vexils
vexing17479173vexing
vomica1336383vomica
xenia124814773xeni_a
xenic144114643xenic_
xeric144315663xeric_

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161955.23321539.5
3Display Results1951950.0633095.2
 (SQL Overall)1786911955.67231504.1
 
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.