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

162 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
glistens936659(None) 
glisten8418081glisten_
glisters93912601glisters
listens74014131_listens
blisters104015082blisters
glistened11174282glistened
glister84013342gliste_r
glitters93710542glitters
glutens8437592gl_utens
gristers94013402gristers
klisters123910482klisters
listees73416672_listees
listels74212432_listels
listen64816812_listen_
listers74026532_listers
moistens10268772moistens
aliens65619213ali__ens
bilsteds1134273bilsteds
bisters93922613_bisters
blasters104116143blasters
blisses94911513blisse_s
blister94415313bliste_r
blistery13418713blistery
blites84721213bli_te_s
blusters104413893blusters
chastens13429183chastens
christens14125413christens
cisterns10369573_cisterns
cloisters1137433cloisters
clusters102912403clusters
clysters13227843clysters
colistins1149223colistins
crispens12286253crispens
distend93312073_distend
distends10339823_distends
distent84120853_distent
elastins82111743elastins
elisions82210423elisions
elites66027123eli_te_s
enlistees954583enlistees
enlisters937113enlisters
existent1548263existent
existents1644983existents
fastens105511753_fastens
filisters1237003filisters
flattens11357483flattens
flirters11337933flirters
flites95122443fli_te_s
flitters114312173flitters
flusters113811503flusters
gagsters10317083gagsters
gaiters83516543gai_ters
ganisters10248313ganisters
gasters85624293g_asters
genisteins1142723genisteins
gestes75721393g_este_s
giftees11306513g_iftees
gists66026193g_ist__s
gites65630183g_i_te_s
gitterns9326573g_itterns
givens10379733g_i_vens
gladdens11364463gladdens
glasses84414273glasse_s
glens66519853gl___ens
gliadins1035193gliadins
glibness1134133glibness
gliders94811843gli_ders
glides84518863gli_de_s
glimes94717523gli_me_s
glimmers13396153glimmers
glinted9399373glinte_d
glinting103210053glinting
glints75714213glint__s
glistening1294283glistening
glistered11176303glistered
glistering12106423glistering
glitter84211803glitte_r
glittery12375613glittery
glitzes17367563gli_tzes
gloaters9288863gloaters
glossers9319053glossers
glosses84014123glosse_s
glosts74513813glost__s
gluten74210753gl_uten_
glutes74517673gl_ute_s
gluteus8386253gl_uteus
gluttons944273gluttons
goiters84014443goi_ters
greatens9307593greatens
greisens954653greis_ens
grifters12389233grifters
griskins1335953griskins
grisons838993gris_ons
grister83915413griste_r
gristles9189203gristles
grists74716483grist__s
gritters94210633gritters
guises74216313guis_e_s
gypsters1434023gypsters
hastens106214813_hastens
heisters113413133heisters
hoisters113513483hoisters
keisters123212043keisters
kittens11347583_kittens
klister113410643kliste_r
lasters75627693_lasters
latens64620213_l_atens
lattens75014673_lattens
leisters83312823leisters
lessens7409383_lessens
lichens123510683_lichens
liens56525503_li__ens
lifters104313783_lifters
lightens122510003_lightens
likens105613703_li_kens
limens84618033_li_mens
lindens839413_lindens
linens64818393_li_nens
lintels73311163_lintels
linters73822633_linters
lippens11328533_lippens
lisles63416283_lisle_s
lispers94514323_lispers
listed74322833_liste_d
listee64223063_liste_e
listel64214743_liste_l
listened9168813_listened
listener8158313_listener
listeners9147323_listeners
lister64527253_liste_r
listing84020593_listing
listings93310043_listings
listless8269263_listless
lists56628693_list__s
liters65429883_li_ters
litten64014873_litten_
litters73422573_litters
livens94314893_li_vens
lusters73921443_lusters
meisters103313843meisters
mispens11311073_mispens
mistend103812523_mistend
mistends11419593_mistends
misters93927513_misters
mittens9349883_mittens
moisten93110143moisten_
oldsters996733oldsters
pistes85325633_piste_s
pistons93016373_pistons
plaisters1137813plaisters
plasters103518133plasters
platens94213983pl_atens
plisses94411773plisse_s
quietens17246343quietens
roisters83615553roisters
sisters73721593_sisters
slickens14317263slickens
slitters84014133slitters
twisters11268173twisters
ulsters72711983ul_sters
waisters113811523waisters
whitens13428733whi_tens

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 Limit1461621626.89021213.6
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.37324235.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.