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

231 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
glad6562401(None) 
clad76225821clad
gad57556651g_ad
glade75121961glade
glads75620611glads
glady105413941glady
glam76529341glam
gland75217711gland
gled65631141gled
goad66830981goad
grad66829861grad
lad48165701_lad
ad311975032__ad
ala312463602ala_
alae45643752alae
alan46844082alan
aland65526412aland
alar46340072alar
alas46358122alas
bad67763152_bad
bald76432902bald
bead75937922bead
beglad10138462beglad
blab86629132blab
blade85923332blade
blae66134642blae
blah98625062blah
blam86131702blam
bland85320452bland
blat66550952blat
blaw97026722blaw
bled75729312bled
brad75234342brad
cad67456362_cad
chad105525502chad
clade85821012clade
clads85722732clads
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
claw95624342claw
clay95927412clay
clod76124612clod
dad58456162_dad
dead65434242dead
duad66521412duad
dyad96415452dyad
egad64215412egad
elan46734242elan
eland65820392eland
eld46733792el_d
fad77452412_fad
flab96628352flab
flag87427082flag
flak116026172flak
flam96333292flam
flan76134182flan
flap96128702flap
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
fled85429772fled
gab67155992g_ab
gadi66329722g_adi
gads67843382g_ads
gae46457702g_ae
gaed66031512gaed
gag57753632g_ag
gal46055512g_al
gala55635162gala
galah95917622galah
galas65731642galas
galax135314462galax
gale56347322gale
gall56335992gall
gals57946502gals
gam67060062g_am
gan48060122g_an
gap67055612g_ap
gar47259902g_ar
gas48870252g_as
gat46880512g_at
gaud67025432gaud
gay76856492g_ay
gear55934972gear
ged57044532g_ed
geed65435502geed
gelada837622gelada
geld65828432geld
gelid74916972gelid
ghat86435282ghat
gid57047262g_id
gied64631982gied
gild65526512gild
gird65424992gird
glace87420152glace
glades84820342glades
gladly11497932gladly
glair65313552glair
glams85822932glams
glands85314402glands
glans65125832glans
glare65222952glare
glared84715192glared
glary96018542glary
glass65518132glass
glaze155418162glaze
glazed174711772glazed
glazy187410982glazy
gleam86916732gleam
glean65818202glean
glede75517832glede
gleds75417892gleds
glee55239062glee
gleed75320572gleed
gleg66219802gleg
glen56027202glen
gley85724652gley
glia56423152glia
glial66715432glial
glias64618492glias
glib79421432glib
glide74521592glide
glim76026352glim
gloam86015942gloam
gloat65427682gloat
glob76623392glob
glom75424382glom
glop76724632glop
glow85222522glow
glue55628492glue
glued75118362glued
glug66118012glug
glum75825102glum
glut56331292glut
gnar56021382gnar
gnat56034432gnat
gnaw86515742gnaw
goa47343802goa_
goads77022852goads
goal55829302goal
goas55239942goas
goat56250832goat
god57449792g_od
gold65430162gold
gonad75216052gonad
good66531802good
gowd96519982gowd
grab75427612grab
grade75126092grade
grads75625752grads
gram77034582gram
gran56335012gran
grand75122692grand
grat55651282grat
gray85329892gray
grid65829612grid
guan55325582guan
guar56923292guar
guard74415542guard
guid66022822guid
gulag7310822gulag
gular6314832gular
had77658762_had
head87137172head
iliad64613452iliad
la219261632_la_
lab58864782_lab
lac510155822_lac
lade56345982_lade
lads56549132_lads
lady86527152_lady
lag47862122_lag
laid56439142_laid
lam57666712_lam
land56337302_land
lap58565272_lap
lar37967532_lar
lard56742002_lard
las37281472_las
lat37593402_lat
laud56527722_laud
lav66847342_lav
law68656642_law
lax107651522_lax
lay68865352_lay
lead56038852lead
led46254552_led
lid47453512_lid
load56730602load
mad68958702_mad
mead75531602mead
ogled75915962ogled
old47033462ol_d
orad56031692orad
pad68057322_pad
plaid85118302plaid
plan65833942plan
plat66048872plat
play95928982play
plead85818462plead
pled75231432pled
plod76723272plod
quad144618702quad
rad47662002_rad
read55942532read
road56332112road
sad47459202_sad
salad65321832salad
scad75725762scad
shad86230912shad
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slid55828982slid
tad47959822_tad
toad55830182toad
trad55630912trad
ulan46527392ulan
ulnad65611452ulnad
wad77053892_wad
woad85523942woad
yald86920602yald
yclad11246382yclad

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 Filter178691298720.0802233637.5
2DLD Change Limit298722310.90333080.8
3Display Results2312310.0504620.0
 (SQL Overall)1786912311.033172982.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.