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

118 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
lichened143575(None) 
richened1435951richened
lechered1437522lechered
licenced13145782lic_enced
licensed11145722lic_ensed
lichee114017972liche_e_
lichees123512782liche_es
lichen114012742lichen__
lichenin1345052lichenin
lichens123510682lichen_s
lichted13268802lich_ted
lightened1446022lightened
likened12267352li_kened
lippened13255222lippened
listened9168812listened
livened11238932li_vened
sickened1546782sickened
slickened1644292slickened
achene11313813_achene_
achenes12313493_achenes
aliened81011743ali__ened
bickered17108003bickered
blackened1845273blackened
blithered15156123blithered
cacheted16148233cacheted
chefed155010563__chefed
chewed154415013__chewed
chickened2144623chickened
chined125620063__chined
ciphered1637053ciphered
cliched153711023clich__ed
dickered16117533dickered
dithered13189293dithered
dizened18267333di_zened
eschewed1743443eschewed
flichtered1942133flichtered
flickered1943753flickered
glistened11174283glistened
hyphened2044693hyphened
inhered11313163_inhered
kitchenet1844983kitchenet
kittened1334523kittened
lackered15108683lackered
lackeyed18104513lackeyed
ladened979053l_adened
latened8711923l_atened
lathered121512333lathered
leadened1036153leadened
leavened1235553leavened
leched123716003lech__ed
lessened935103lessened
libeled10249413li_beled
licence11119373lic_ence
licencee12116473lic_encee
licencer12146143lic_encer
licences12129333lic_ences
license9148423lic_ense
licensee10166303lic_ensee
licenser10155883lic_enser
licenses10118923lic_enses
licente91210893lic_ente
lichening1545673lichening
lichenins1444843lichenins
lichenose1443363lichenose
lichenous1444313lichenous
liches114724293lich__es
licked134621563lic__ked
lighted122913503ligh_ted
lightener1345693lightener
lightered1446283lightered
limbered13158123limbered
limned94811473li__mned
lined64934643li___ned
lingered10129643lingered
linseed838203linse_ed
lippered13287953lippered
listener8158313listener
litheness1247363litheness
lithoed1137833lith_oed
littered92511383littered
livener10278943li_vener
livered113111633li_vered
loosened945453loosened
loudened1044693loudened
lychee143710893lyche_e_
lychees15516783lyche_es
machined1637303machined
miched143913393mich__ed
mildened1235773mildened
mittened1136363mittened
niched125514063nich__ed
nickeled15115513nickeled
nickered15117023nickered
ochered132610283_ochered
picketed17167383picketed
pinkened1535753pinkened
quickened2543163quickened
racheted14149503racheted
rechewed1735633rechewed
richen113812513richen__
richens12349733richen_s
richweed17163583richweed
ripened1038213ri_pened
sacheted14127833sacheted
schemed1577753_schemed
sickener1436603sickener
siphoned1446413siphoned
slackened1644243slackened
slickener1544043slickener
slithered13136623slithered
thickened1944303thickened
ticketed15146643ticketed
tightened1444963tightened
tochered1437913tochered
unchewed1735803unchewed
widened12328053wi_dened
withered15169433withered
wizened20275423wi_zened

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.453394461.4
2DLD Change Limit1461621186.72021750.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.21924752.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.