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

235 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
elicit841720(None) 
elicits9311231elicits
licit74327681_licit
deficit1339672deficit
delict94320332delic_t
delimit10311732delimit
edict84722282edic_t
elect74327032elec_t
elegit71212892elegit
elicited1139092elicited
elicitor1045772elicitor
elint55436472eli_nt
elitist7414912elitist
elixir1333702elixir
evict104417142evic_t
explicit1946462explicit
felicity1647912felicity
helicity1648502helicity
illicit949832illicit
licht104723492_licht
limit73126342_limit
relict83623902relic_t
solicit9315742solicit
albeit8314343albeit
alcid85817973al_cid
alibi7514233alibi_
alibis8311073alibis
alight103816863alight
alist56136783ali_st
alit46155693al__it
aliyot93611713aliyot
allicin949953allicin
amici94217393amici_
binit76431583_binit
blight124114623blight
blini75519273blini_
blinis85313683blinis
cliche133712453cliche
click135217953clic_k
clicks145315113clicks
client8316343client
clift106422193cli_ft
clinic104312793clinic
clipt96324273cli_pt
clitic103315053clitic
clivia1177233clivia
colicin11313743colicin
culicid1247383culicid
deficits1447273deficits
delicate11315493delicate
delicts104012253delicts
delight12610673delight
delimits1137573delimits
deliria868303deliria
delist74625053deli_st
depict113514793depic_t
dicot85429093_dicot
digit73825273_digit
dixit134420593_dixit
echt95722903e__cht
edacity1336373edacity
edicts94911703edicts
edit54934863e__dit
educt85017103educ_t
eeliest73516473eeliest
eight94928053e_ight
eject145016043ejec_t
elain55324703el_ain
elapid939543elapid
eldest72912683eldest
elects83315003elects
elegist81311973elegist
elegits8149343elegits
elemi7312503elemi_
elemis8312383elemis
elfin84312463el_fin
elhi7612403el_hi_
eliciting1237773eliciting
elicitors1145803elicitors
elide64922643eli_de
elided84814673elided
elides74420693elides
eliding93414343eliding
elints65816423elints
elision72311103elision
elite56230183eli_te
elites66027123elites
elitism939763elitism
elitists848543elitists
elixirs1443543elixirs
elmiest9310743elmiest
eloin55923203el_oin
eluant6315093eluant
eluent6315483eluent
eluvia936133eluvia
emic86422753emic__
emit65438423e__mit
enact73525363enac_t
enlist6417043enli_st
epact94921533epac_t
epic86921303epic__
epical10413393epical
epics95014283epic_s
episcia1145133episcia
erect74129333erec_t
erica7316543eric_a
ericas8315463ericas
ericoid1049893ericoid
eruct74022353eruc_t
escot75320083e_scot
esprit8312843esprit
ethicist1347893ethicist
etic66123953etic__
evicts11368553evicts
exact143516933exac_t
excite15310883e_xcite
exhibit1945253exhibit
exilic1597783exilic
exist124618943exi_st
exit114428673e__xit
explicits2044933explicits
felinity1447283felinity
ficin103516723_ficin
fixit154819303_fixit
flic96223733flic__
flick145017213flic_k
flicks154512993flicks
flics105418363flic_s
fliest94718433fliest
flight134014813flight
flint87333503fli_nt
flirt87424753fli_rt
flit76539273fl__it
gelidity1345573gelidity
glacis94012133glacis
glaikit1244633glaikit
glint66830183gli_nt
glycin1235963glycin
heliast10312073heliast
helical12311153helical
helices12313723helices
helicoid1446753helicoid
helicon1237643helicon
helicopt1547033helicopt
helictite1445973helictite
helilift1445183helilift
hellcat12410173hellcat
implicit1446813implicit
kainit10414483kainit
klick105311433klic_k
klicks11468723klicks
legit61323503_legit
leucin839113leucin
leucite937753leucite
lice66045063_lic_e
lich96230843_lic_h
lichi104412953_lichi
lichis115212593_lichis
lichts113712383_lichts
licitly12276673_licitly
lick106935073_lic_k
licks115325393_licks
lift76942723_li_ft
light94429603_light
lilt46349943_li_lt
limits82514143_limits
linin58025523_linin
lint416266233_li_nt
lipid85916173_lipid
lipin75518893_lipin
liri45128253_liri_
lirot5430033_lirot
list47055343_li_st
lit39377313_l__it
livid96714423_livid
loci66126283_loci_
lucid84314573_lucid
lucite8313343_lucite
melic94722333melic__
melilite10410573melilite
melilot9311083melilot
melinite10411753melinite
ocicat101412813ocicat
pelican1139433pelican
pelitic111814653pelitic
penicil1138833penicil
picot95031013_picot
pipit95224873_pipit
placet103923673placet
placid114012543placid
plait75631573pl_ait
pliant83918823pliant
plica9613373plic_a
plicae10410953plicae
plical10411683plical
plicate11314513plicate
plight123513363plight
prelimit1259123prelimit
recit75235103_recit
reliant7319243reliant
relic74623363relic__
relics84517903relic_s
relicts94414593relicts
relight11512063relight
relist64628413reli_st
relit55340683rel__it
reluct83916113reluc_t
revisit10311373revisit
ricin74620213_ricin
salicin9311223salicin
select82621173selec_t
semifit1249973semifit
sericin9312843sericin
silicic1147603silicic
slice74925823slic_e
sliced94416313sliced
slicer84117603slicer
slices84022853slices
slicing103514643slicing
slick115520523slic_k
slicks124816113slicks
sliest66621953sliest
slight103416003slight
slipt76627483sli_pt
slit46250103sl__it
solicits10311023solicits
spirit83519923spirit
stickit1339463stickit
tacit76333673_tacit
telic76019823telic__
tricot8317753tricot
twilit949553twilit
velocity1644953velocity
visit8320963_visit
zizit13313273_zizit

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.373479064.3
2DLD Change Limit1127162355.17321789.3
3Display Results2352350.0763092.1
 (SQL Overall)1786912355.62231784.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.