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

168 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
gleds7541789(None) 
geds66730811g_eds
gelds75118341gelds
glads75620611glads
gled65631141gled_
glede75517831glede
gledes84915131gledes
gleeds84711621gleeds
glees65027591glees
glens66519851glens
gleys96514851gleys
sleds64418851sleds
aglets73915682aglets
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
beds75937782_beds
blebs96416152blebs
bled75729312bled_
bleeds95211592bleeds
blends96012882blends
bless75917812bless
blets75324942blets
clads85722732clads
clefs106616242clefs
clews105516332clews
clods85320862clods
coeds85920162coeds
creds85418772creds
deeds75423762deeds
eds46638922__eds
elds56324852el_ds
feds85234312_feds
feeds94921142feeds
fleas86423662fleas
fled85429772fled_
flees85828752flees
flews115316442flews
fleys117015602fleys
gads67843382g_ads
gaed66031512gaed_
gaes56348032gae_s
galeas74618512galeas
gales65442482gale_s
gauds75717722gauds
ged57044532g_ed_
geed65435502geed_
geeks104915842geeks
gees55647882g_ees
geld65828432geld_
gelees74116262gelees
gels56836102g_els
gelts65924612gelts
gems75329112g_ems
gens55740072g_ens
gets55442482g_ets
ghees95215552ghees
gids65933742g_ids
gied64631982gied_
gies55641422gie_s
gilds75417522gilds
girds74816992girds
glad65624012glad_
glade75121962glade
glades84820342glades
glady105413942glady
glams85822932glams
glands85314402glands
glans65125832glans
glass65518132glass
gleam86916732gleam
gleams94812252gleams
glean65818202glean
gleans75014742gleans
gleba83910242gleba
glebe85016442glebe
glebes95512242glebes
glee55239062gle_e
gleed75320572gleed
gleek105315102gleek
gleeks11489672gleeks
gleet65532342gleet
gleets75315052gleets
gleg66219802gle_g
glen56027202gle_n
gley85724652gle_y
glias64618492glias
glide74521592glide
glides84518862glides
glims87417672glims
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
glued75118362glued_
gluers75011152gluers
glues65125682glues
glugs75214282glugs
glums84621422glums
gluts66120132gluts
goads77022852goads
gods65438042g_ods
goers65520252goers
goes55644092goe_s
golds75421312golds
golems939322golems
goods75124482goods
gowds105814042gowds
grads75625752grads
greeds84314282greeds
grees65132472grees
greys96614852greys
grids75321392grids
gudes74520812gudes
guess64213362guess
guids75516152guids
gules64831042gule_s
heeds95420422heeds
ileus54616892ileus
lads56549132_lads
leads66028492_leads
leas45954182_leas
led46254552_led_
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lends65326252_lends
lens46146492_lens
les35663072_le_s
less45635102_less
lets47147942_lets
leuds66214812_leuds
leys76430182_leys
lids56336462_lids
meds75735362_meds
meeds84920272meeds
melds84822382melds
naleds7469132naleds
needs65719632needs
ogled75915962ogled_
oglers74313182oglers
ogles65223182ogle_s
olds55926572ol_ds
oleos55419682oleos
oles46453472ole_s
peds75835242_peds
pleads94613952pleads
pleas75627032pleas
plebs95814582plebs
pled75231432pled_
plews105415352plews
plods85719292plods
reds56042862_reds
reeds65430902reeds
seeds64330062seeds
sheds96122702sheds
sled55334372sled_
slews86220352slews
sneds65715352sneds
teds54932572_teds
velds95615582velds
weds86628932_weds
weeds95222212weeds
welds94719162welds
ylems1039262ylems
zeds145821802_zeds

Search took 2 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.313570897.8
2DLD Change Limit538001681.51335558.5
3Display Results1681680.0503360.0
 (SQL Overall)1786911681.87695251.1
 
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.