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

116 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
listeners914732(None) 
listener8158311listener_
distenders12166732distenders
fasteners12237052fasteners
hasteners12267812hasteners
lighteners1444982lighteners
listees73416672liste_e_s
listened9168812listene_d
listens74014132listen__s
listers74026532list__ers
liteness82213212li_teness
litterers9228192litterers
liveners11217932li_veners
moisteners1244782moisteners
alieners889823ali__eners
batteners11238163batteners
bisters93922613bist__ers
blisters104015083blist__ers
blusterers12174993blusterers
chasteners1554793chasteners
discerners1345703discerners
dispensers13146743dispensers
dissenters1197723dissenters
dissevers1386863dissevers
distempers1544293distempers
distender11167743distender_
distends10339823disten_ds
easterners1044823easterners
fastener11227833fastener_
fatteners12236873fatteners
filterers12206973filterers
flatteners13164153flatteners
fosterers12238023fosterers
glistened11174283glistene_d
glistens9366593glisten__s
glisters93912603glist__ers
hastener11259133hastener_
histones11312803histone_s
hostelers1246643hostelers
integers937783_integers
intenders10219373_intenders
intoners889933_intoners
klisters123910483klist__ers
larceners1135993larceners
lasters75627693last__ers
lateeners945563lateeners
lateness82614073l_ateness
leisters83312823leist__ers
letterers9228113letterers
libelers10238623li_belers
licencers13134643li_cencers
licensers11114583li_censers
lifters104313783lift__ers
lightener1345693lightener_
likeness12229863li_keness
limners93311563li__mners
liners65428853li___ners
lingerers10126923lingerers
linters73822633lint__ers
lispers94514323lis__pers
listee64223063liste_e__
listels74212433list__els
listen64816813listen___
listenership1762003listenership
listening10128953listening
lister64527253list__er_
listerias959233listerias
listings93310043listin_gs
listless8269263list_less
liters65429883li_t__ers
litheness1247363litheness
litterer82810173litterer_
litters73422573li_t_ters
littleness1045023littleness
livener10278943li_vener_
liveness112411393li_veness
lobsterers1243483lobsterers
loiterers936263loiterers
looseners945403looseners
lostness837683lost_ness
lusters73921443lust__ers
lustiness92010453lustiness
misenters1139533mis_enters
misrefers1445363misrefers
misrenders1375353misrenders
missteers1135913misste_ers
mistakers15117083mistakers
mistends11419593misten_ds
misters93927513mist__ers
mistiness111911633mistiness
mistunes10311133mistune_s
miterers10219683mi_terers
moistener1145843moistener_
oysterers1245573oysterers
pesterers112510463pesterers
pilseners1144943pilseners
plasterers1286123plasterers
quieteners1942983quieteners
ratteners9237263ratteners
ripeners1036833ri_peners
roisterers1045113roisterers
sickeners1535733sickeners
sisters73721593sist__ers
slickeners1643663slickeners
softeners1245133softeners
steers63820983__ste_ers
stoners74817953__stoners
tighteners1444043tighteners
titterers9236993titterers
vintners1134573vint_ners
westerners1344473westerners
whiteners1535243whiteners
wideners12257993wi_deners
wieners103212483wi__eners
winterers12209723winterers
wiseness112010753wis_eness

Search took 10 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 Filter1786911486410.890200776.4
2DLD Change Limit1486411168.39317710.1
3Display Results1161160.0631841.3
 (SQL Overall)1786911169.34619119.5
 
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.