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

175 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
listened916881(None) 
glistened11174281glistened
listener8158311listener
bistered112913332bistered
blistered12167682blistered
distend93312072disten_d
distended12157922distended
fastened12257852fastened
glistered11176302glistered
hastened12239102hastened
kittened1334522kittened
latened8711922l_atened
leistered1037042leistered
lessened935102lessened
lichened1435752lichened
lightened1446022lightened
likened12267352li_kened
lippened13255222lippened
listed74322832list__ed
listee64223062liste_e_
listees73416672liste_es
listen64816812listen__
listeners9147332listeners
listens74014132listen_s
littered92511382littered
livened11238932li_vened
lustered92510612lustered
mistend103812522misten_d
mistended13137332mistended
mistuned1157722mistuned
mittened1136362mittened
moistened1246002moistened
sistered92612802sistered
aliened81011743ali__ened
battened11259573battened
bistred103311853bist_red
bittered112711833bittered
blustered12157263blustered
chastened1545883chastened
christened1643623christened
cisted95217523cist__ed
cloistered1344523cloistered
clustered12186613clustered
crispened1443613crispened
destined103312453destined
discerned1347863discerned
disowned1336433disowned
dispend11289413dispen_d
dispended14147823dispended
dispensed13158773dispensed
dissented1199723dissented
distained1139603distained
distanced1348573distanced
distender11167743distender
distends10339823distends
distent84120853disten_t
dizened18267333di_zened
fastener11227843fastener
fattened12268283fattened
festered122512113festered
filtered12259043filtered
fisted104218703fist__ed
flattened13185303flattened
flittered13196253flittered
flustered13185883flustered
fostered122210453fostered
glisten8418083glisten__
glistens9366593glisten_s
glittered11195413glittered
hastener11259143hastener
histed104420243hist__ed
histone10312843histone_
histones11312803histones
hosteled1237293hosteled
intend72310373_inten_d
intended102310413_intended
interned93016653_interned
intoned8811993_intoned
isleted837523_isleted
itemed936603_i_temed
jittered16267223jittered
ladened979053l_adened
lasted74323603last__ed
leadened1036153leadened
leavened1235553leavened
lesioned936903lesioned
lessoned945393lessoned
lettered92910783lettered
libeled10249413li_beled
licenced13145783li_cenced
licensed11145723li_censed
lifted104413523lift__ed
lightener1345693lightener
lightered1446283lightered
lilted73715373lilt__ed
limbered13158123limbered
limned94811473li__mned
lined64934643li___ned
lingered10129643lingered
linseed838203linse_ed
linted74021823lint__ed
lippered13287953lippered
lisente71210703lis_ente
lisped94113423lis__ped
listel64214743list__el
listels74212433liste_ls
listening10128953listening
lister64527253list__er
listeria839453listeria
listers74026533liste_rs
listing84020593listin_g
listings93310043listings
liteness82213213li_teness
lithoed1137833li_thoed
litten64014873litten__
litterer82810173litterer
livener10278943li_vener
livered113111633li_vered
lobstered1244643lobstered
loitered938183loitered
loosened945453loosened
loudened1044693loudened
lusted74319443lust__ed
lustred8359053lust_red
mastered112614013mastered
mildened1235773mildened
misatoned1246693misatoned
misdeed113211053misde_ed
misfeed13389683misfe_ed
mispenned1445413mispenned
missend104411373missen_d
misted93625823mist__ed
mistends11419593mistends
mistermed1438363mistermed
mistimed1339123mistimed
mistune9310653mistune_
mistunes10311133mistunes
mistyped1685173mistyped
mitered103213233mi_tered
moistener1145843moistener
mustered112511513mustered
neatened937043neatened
oystered1236923oystered
pattened11299393pattened
pestered112814973pestered
pinkened1535753pinkened
pistoled11259593pistoled
plaistered1344133plaistered
plastered1288913plastered
quietened1943363quietened
rattened9218623rattened
richened1435953richened
ripened1038213ri_pened
roistered1037653roistered
sickened1546783sickened
sintered92213903sintered
slickened1644293slickened
softened1235663softened
staned74824643__staned
steed66024943__ste_ed
stewed104814243__stewed
stoned75923143__stoned
tautened935423tautened
tightened1444963tightened
tittered9239493tittered
unstoned9311043unstoned
viseed105310983vis_e_ed
visioned1247013visioned
vistaed1138023vist_aed
westered122511873westered
whitened1535183whitened
widened12328053wi_dened
wintered122111573wintered
wisted104120273wist__ed
wizened20275423wi_zened

Search took 9 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 Limit1461621757.92018454.8
3Display Results1751750.0802187.5
 (SQL Overall)1786911758.45321139.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.