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

156 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
gleed7532057(None) 
bleed85019801bleed
geed65435501g_eed
gled65631141gl_ed
glede75517831glede
glee55239061glee_
gleeds84711621gleeds
gleek105315101gleek
glees65027591glees
gleet65532341gleet
gleyed11478151gleyed
glued75118361glued
greed75125691greed
aglee65728492aglee_
agreed84712502agreed
alee46652322alee_
bled75729312bl_ed
bleeds95211592bleeds
bleep95013452bleep
blend85317452blend
blued84520322blued
breed85526692breed
cleek115514912cleek
cleped115114112cleped
clewed1225113202clewed
clued84917682clued
creed85727392creed
deed65340902_deed
deled75326542deled
dreed75222842dreed
feed84538902_feed
fled85429772fl_ed
flee76238792flee_
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flexed17419092flexed
fleyed13408812fleyed
flied96519432flied
flued95021252flued
freed95223542freed
gaed66031512g_aed
gaged85522312gaged
galled84622862galled
gamed95126392gamed
gaped96123532gaped
gated75329772gated
gazed165520332gazed
ged57044532g__ed
gee45359202g_ee_
geek95327022g_eek
geeked124510162geeked
gees55647882g_ees
geez146424862g_eez
geld65828432g_eld
gelded94512112gelded
gelee63626982gelee
gelees74116262gelees
gelid74916982gelid
gelled84718892gelled
ghee85726112ghee_
ghees95215552ghees
gibed96215962gibed
gied64631982g_ied
gilded94413222gilded
gilled84521632gilled
glaceed1136192glaceed
glad65624012gl_ad
glade75121962glade
gland75217712gland
glared84715192glared
glazed174711772glazed
gleam86916732gleam
gleamed11327932gleamed
glean65818202glean
gleaned9349422gleaned
gleba83910242gleba
glebe85016442glebe
glebes95512242glebes
gledes84915132gledes
gleds75417892gleds
gleeked13346332gleeked
gleeks11489672gleeks
gleeted9379322gleeted
gleets75315052gleets
gleety10479192gleety
gleg66219802gl_eg
glen56027202gl_en
glens66519852glens
gley85724652gl_ey
gleys96514852gleys
glide74521592glide
glided94513902glided
glimed105312282glimed
globed104811762globed
gloved114811872gloved
glowed114913832glowed
glozed173711222glozed
glue55628492glue_
gluer65116772gluer
glues65125682glues
gluey95715262gluey
golfed11569762golfed
gored75227082gored
gree56641562gree_
greeds84314282greeds
greedy11518852greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
gulfed114810012gulfed
gulled84521372gulled
gulped104610372gulped
guyed1049892guyed
gybed125811022gybed
gyred105114092gyred
gyved13568742gyved
heed86437602_heed
jeed125428502_jeed
kneed104612052kneed
lead56038852_lead
led46254552_l_ed
lee36068142_lee_
leek85331732_leek
leer46239352_leer
lees45455882_lees
leet45957902_leet
lend56233672_lend
leud57223422_leud
lewd85716592_lewd
lied55838092_lied
meed74934702_meed
need54934152_need
ogled75915962ogl_ed
peed76239182_peed
plead85818462plead
pled75231432pl_ed
plied85118592plied
preed85128122preed
reed55549622_reed
seed55549482_seed
skeed105018982skeed
sled55334372sl_ed
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slewed104815522slewed
slued64220512slued
speed85526622speed
steed66024942steed
teed55439262_teed
treed65626732treed
tweed94915092tweed
weed85637512_weed

Search took 3 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.436409841.7
2DLD Change Limit538001562.29623432.1
3Display Results1561560.0463391.3
 (SQL Overall)1786911562.77864323.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.