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

154 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
listener815831(None) 
listened9168811listened
listeners9147321listeners
distender11167742distender
fastener11227832fastener
glistened11174282glistened
hastener11259132hastener
lightener1345692lightener
listee64223062liste_e_
listees73416672liste_es
listen64816812listen__
listens74014132listen_s
lister64527252list__er
litterer82810172litterer
livener10278942li_vener
moistener1145842moistener
aliener71011193ali__ener
austerer838383austerer
battener10369393battener
bister84922763bist__er
bistered112913333bistered
bitterer10309773bitterer
blister94415313blist__er
blistered12167683blistered
blusterer11176293blusterer
chastener1445703chastener
discerner1246943discerner
dispenser12128323dispenser
dissenter1059133dissenter
dissever12107653dissever
distemper1444853distemper
distend93312073disten_d
distended12157923distended
distenders12166733distenders
distends10339823distends
distent84120853disten_t
easterner945053easterner
fastened12257853fastened
fasteners12237053fasteners
fattener11268113fattener
filterer11258143filterer
flattener12175173flattener
fosterer11239523fosterer
glisten8418083glisten__
glistens9366593glisten_s
glister84013343glist__er
glistered11176303glistered
hastened12239103hastened
hasteners12267813hasteners
histone10312843histone_
histones11312803histones
hosteler1137283hosteler
integer837993_integer
intender93310443_intender
intenser8199443_intenser
intoner7811673_intoner
kittened1334523kittened
klister113410643klist__er
larcener1036493larcener
laster64830633last__er
lateener835763lateener
latened8711923l_atened
leister73212753leist__er
leistered1037043leistered
lessened935103lessened
letterer8259223letterer
libeler9219003li_beler
licencer12146133li_cencer
licenser10155883li_censer
lichened1435753lichened
lieder74912323li__eder
liefer9529573li__efer
liever94611863li__ever
lifter93814813lift__er
lightened1446023lightened
lighteners1444983lighteners
likened12267353li_kened
limberer12187053limberer
limner84112873li__mner
liner55938923li___ner
lingerer9118303lingerer
linter64625343lint__er
lintier73613803lint_ier
lippened13255223lippened
lisente71210703lis_ente
lisper84114433lis__per
listed74322833list__ed
listel64214743list__el
listels74212433liste_ls
listening10128953listening
listeria839433listeria
listers74026533liste_rs
listing84020593listin_g
listings93310043listings
liteness82213213li_teness
liter54736343li_t__er
lither94520953li_t_her
litten64014873litten__
litter64324853li_t_ter
littered92511383littered
litterers9228193litterers
littler7348553li_ttler
livened11238933li_vened
liveners11217933li_veners
lobsterer1144033lobsterer
loiterer837083loiterer
loosener845633loosener
luster64023673lust__er
lustered92510603lustered
lustier73813503lust_ier
misenter10310833mis_enter
misrefer1346103misrefer
misrender1286293misrender
missteer1037223misste_er
mistaker14109333mistaker
mistend103812523misten_d
mistended13137333mistended
mistends11419593mistends
mister84728563mist__er
mistier93418713mist_ier
mistune9310653mistune_
mistuned1157723mistuned
mistunes10311133mistunes
miterer92511333mi_terer
mittened1136363mittened
moistened1246003moistened
moisteners1244783moisteners
obscener1244323obscener
oftener1035923_oftener
oysterer1136103oysterer
pesterer102412713pesterer
pilsener1044753pilsener
plasterer1178113plasterer
quietener1843353quietener
rattener8238533rattener
ripener937903ri_pener
roisterer946433roisterer
rottener8216973rottener
sickener1436603sickener
sister64421583sist__er
sistered92612803sistered
slickener1544043slickener
softener1145613softener
steer55423863__ste_er
sterner7411913__sterner
stoner65823203__stoner
tightener1344703tightener
titterer8268523titterer
vintner1034833vint_ner
westerner1244963westerner
whitener1435733whitener
widener11318693wi_dener
wiener94513543wi__ener
winterer112110443winterer

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.420425454.8
2DLD Change Limit1461621547.25020160.3
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.73323107.6
 
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.