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

154 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
glade7512196(None) 
blade85923331blade
clade85821011clade
glace87420151glace
glad65624011glad_
glades84820341glades
glads75620611glads
glady105413941glady
glare65222951glare
glaze155418161glaze
glede75517831glede
glide74521591glide
grade75126091grade
lade56345981_lade
aglare7312422aglare
alae45643752ala_e
alane56135612alane
alate55340322alate
alcade91111512alcade
bade75140882_bade
bladed104717762bladed
blader93618582blader
blades95221252blades
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
cade76443912_cade
clad76225822clad_
clades94920462clades
clads85722732clads
clave105420152clave
elate55335882elate
elide64922642elide
elude64517622elude
evade938182evade
fade85736342_fade
flake125119972flake
flame105124442flame
flare84823632flare
gad57556652g_ad_
gadi66329722g_adi
gadje1457742g_adje
gads67843382g_ads
gae46457702g_a_e
gaed66031512g_aed
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gape75134512g_ape
gate55746572g_ate
gave84634052g_ave
gaze145032412g_aze
gelada837622gelada
gelate73421252gelate
geode7412592geode
glaces94218022glaces
gladded11357452gladded
gladden10376312gladden
gladder10398312gladder
gladier93810992gladier
gladly11497932gladly
glair65313552glair
glaire74411292glaire
glaive10357932glaive
glam76529342gla_m
glams85822932glams
glance94312312glance
gland75217712gland
glandes95413832glandes
glands85314402glands
glans65125832glans
glared84715192glared
glares75518862glares
glary96018542glary
glass65518132glass
glazed174711772glazed
glazer164212262glazer
glazes165315642glazes
glazy187410982glazy
glebe85016442glebe
gled65631142gled_
gledes84915132gledes
gleds75417892gleds
glee55239062gl_ee
gleed75320572gleed
glided94513902glided
glider84614262glider
glides84518862glides
glime85620192glime
globe84917012globe
glove94516292glove
gloze154815982gloze
glue55628492gl_ue
glued75118362glued
glume85120462glume
glute66020902glute
goad66830982goad_
goaded94913712goaded
goads77022852goads
grace85124542grace
grad66829862grad_
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
gride75223582gride
gude65423332g_ude
guide75019882guide
hade85440192_hade
irade65618152irade
jade125325442_jade
lace66848472_lace
lad48165702_lad_
laded74232612_laded
laden65022192_laden
lader65633722_lader
lades65141272_lades
ladle66320442_ladle
lads56549132_lads
lady86527152_lady
lake85741602_lake
lame66849292_lame
lane45153332_lane
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lode56240112_lode
lude55331642_lude
made75440242_made
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
sade55544472_sade
shade95125582shade
slake93724052slake
slate55438282slate
slave84224032slave
slide64725412slide
spade84423322spade
stade64825302stade
trade65026042trade
tsade64311122tsade
unlade72714152unlade
wade85237062_wade

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.0931921408.6
2DLD Change Limit538001541.62633087.3
3Display Results1541540.0305133.3
 (SQL Overall)1786911541.749102167.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.