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

142 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
elicited113909(None) 
delimited1346592delimited
elected102812612elec_ted
elicit8417202elicit__
elicitor1045772elicitor
elicits9311232elicit_s
evicted1337242evic_ted
excited1737852e_xcited
lichted13268802_lichted
limited102310232_limited
plicated13310642plicated
solicited1247972solicited
alibied1038143alibi_ed
alighted1347673alighted
blighted1546863blighted
cited84421953___cited
cliched153711023clic_hed
clicked164112453clic_ked
dedicated14310253dedicated
delicate11315493delicate_
delicates12314313delicates
delighted1546203delighted
delimiter1246243delimiter
delisted10310563deli_sted
depicted1437743depic_ted
edified12339713edifi_ed
edited83913673e__dited
educated1237943educated
ejected17297653ejec_ted
elated74725823el__ated
electee92513243elec_tee
elegised10145923elegised
elegized19145683elegized
elevated12118293elevated
eliciting1237773eliciting
elicitors1145803elicitors
elided84814673el__ided
eliminated1345953eliminated
elite56230183el__ite_
elites66027123el__ites
eloined8149813el_oined
elucidated1464113elucidated
eluted74915263el__uted
eluviated1345333eluviated
emaciated1446933emaciated
emitted103010853emi_tted
enacted10310643enac_ted
endited93512913e_ndited
enlisted978193enli_sted
epilated11310753epilated
erected103213993erec_ted
eructed10228653eruc_ted
escoted1038183e_scoted
ethicized2444933ethicized
evictee1248103evic_tee
evited104013143e__vited
exacted1737303exac_ted
excided1836203e_xcided
excised1736673e_xcised
excite15310883e_xcite_
exciter1637753e_xciter
excites16310633e_xcites
executed1835503executed
exhibited2243303exhibited
existed1538473exi_sted
exited144712523e__xited
explicated22106103explicated
felicitated1743563felicitated
felicities1549743felicities
felicity1647913felicit_y
flichter1664963flichter
flicked174610673flic_ked
flighted1646973flighted
flinted114411893fli_nted
flirted11428673fli_rted
flited104616583fl__ited
flitted114011643fli_tted
glaciated1365763glaciated
glinted9399373gli_nted
helicities1549853helicities
helicity1648503helicit_y
helicopted1852703helicopted
helictite1445973helictite_
helictites1544653helictites
helilifted1752133helilifted
incited103314623_incited
laicised1145643laicised
laicized2046043laicized
lenited8812433_lenited
leucite937753leucite_
leucites1037333leucites
liaised837113_liaised
licit74327683_licit__
licitly12276673_licitly
licked134621563_lic_ked
lifted104413523_li_fted
ligated92414143_ligated
lighted122913503_lighted
lilied73913213_lili_ed
lilted73715373_li_lted
limiteds11184543_limiteds
limiter92710853_limiter
limites92915453_limites
linted74021823_li_nted
listed74322833_li_sted
located103114183_located
lucite8313343_lucite_
lucites9311863_lucites
medicated15410073medicated
medicined1545113medicined
melilite10410573melilite_
melilites1149193melilites
melinite10411753melinite_
melinites11310413melinites
miscited13310423miscited
picoted1239213_picoted
placated1338453placated
plaited103713893pl_aited
plicate11314513plicate_
plighted1546463plighted
precited133013813precited
prelimited1545493prelimited
recited104319103_recited
reincited1246853reincited
relighted1436863relighted
relisted9312623reli_sted
relocated12710813relocated
relucted1138653reluc_ted
replicated1548773replicated
revisited1346573revisited
selected1159783selec_ted
sliced94416313slic__ed
slicked144413843slic_ked
slighted1357393slighted
slitted83513313sli_tted
spicated13309903spicated
spirited1148973spirited
suicided1246033suicided
unlimited1245923unlimited
vellicated1644803vellicated
vesicated15117653vesicated
visited1168773_visited

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621426.64022012.3
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.10925135.9
 
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.