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 “glens” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
glens6651985(None) 
gens55740071g_ens
glans65125831glans
gleans75014741gleans
gleds75417891gleds
glees65027591glees
glen56027201glen_
gleys96514851gleys
lens46146491_lens
aglets73915682aglets
alans55636172alans
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
aliens65619212aliens
amens75624842amens
avens86419332avens
bens65945702_bens
blebs96416152blebs
blend85317452blend
blends96012882blends
blent76230952blent
bless75917812bless
blets75324942blets
brens75823362brens
clans75031012clans
cleans85817052cleans
clefs106616242clefs
clews105516332clews
clons75228132clons
dens55945072_dens
elans55527752elans
ens37245922__ens
evens84817102evens
fens76139762_fens
flans85327972flans
fleas86423662fleas
flees85828752flees
flense938902flense
flews115316442flews
fleys117015602fleys
gaen57329602gaen_
gaes56348032gae_s
gains65729512gains
galeas74618512galeas
galena74911092galena
galenas83310342galenas
gales65442482gale_s
geds66730812g_eds
geeks104915842geeks
gees55647882g_ees
gelds75118342gelds
gelees74116262gelees
gels56836102g_els
gelts65924612gelts
gems75329112g_ems
gen45950512g_en_
gene56237222g_ene
genes65133092g_enes
gent56954392g_ent
gents65729612g_ents
genu55929072g_enu
genus65319832g_enus
gets55442482g_ets
ghees95215552ghees
gien56330022gien_
gies55641422gie_s
gins55543952g_ins
girns64516802girns
givens10379732givens
glads75620612glads
glams85822932glams
gland75217712gland
glands85314402glands
glass65518132glass
gleam86916732gleam
gleams94812252gleams
glean65818202glean
gleba83910242gleba
glebe85016442glebe
glebes95512242glebes
gled65631142gle_d
glede75517832glede
gledes84915132gledes
glee55239062gle_e
gleed75320572gleed
gleeds84711622gleeds
gleek105315102gleek
gleeks11489672gleeks
gleet65532342gleet
gleets75315052gleets
gleg66219802gle_g
gley85724652gle_y
glias64618492glias
glims87417672glims
glint66830182glint
glints75714212glints
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
gluers75011152gluers
glues65125682glues
glugs75214282glugs
glums84621422glums
gluons738502gluons
glutens8437592glutens
gluts66120132gluts
goers65520252goers
goes55644092goe_s
golems939322golems
goons65326772goons
gowns95115102gowns
grans64832542grans
greens75716872greens
grees65132472grees
greys96614852greys
grins65427222grins
guans64419442guans
guess64213362guess
guldens9356572guldens
gules64831042gule_s
guns55533482g_uns
hens75642572_hens
ileus54616892ileus
keens95721182keens
kens85435232_kens
leans55536252_leans
leas45954182_leas
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lend56233672_lend
lends65326252_lends
lenes54738522_lenes
lenis56326862_lenis
leno47331392_leno
lenos56024862_lenos
lense54523432_lense
lent46360532_lent
les35663072_le_s
less45635102_less
lets47147942_lets
leys76430182_leys
liens56525502liens
lins47059052_lins
miens76118302miens
oglers74313182oglers
ogles65223182ogle_s
oleins6313522oleins
oleos55419682oleos
oles46453472ole_s
omens75618962omens
opens76118552opens
ovens86217452ovens
peens76428192peens
pens65649642_pens
plans75731272plans
pleas75627032pleas
plebs95814582plebs
plena75816392plena
pleons84213342pleons
plews105415352plews
sleds64418852sleds
slews86220352slews
teens56227482teens
tens45647412_tens
thens85921832thens
ulans54921302ulans
weens85224052weens
wens76337932_wens
whens114618762whens
wrens85016242wrens
yens75832262_yens
ylems1039262ylems

Search took 4 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 Filter178691538000.656272394.8
2DLD Change Limit538001772.86018811.2
3Display Results1771770.0931903.2
 (SQL Overall)1786911773.60949512.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.