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

178 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
glut5633129(None) 
glout65925811glout
glue55628491glue
glug66118011glug
glum75825101glum
glute66020901glute
gluts66120131gluts
gout56646001gout
gut46753851g_ut
slut45040591slut
abut66834952abut
aglet65534142aglet
alit46155692alit
alt36467962al_t
alum65227612alum
bhut95425712bhut
blat66550952blat
blet66247672blet
blot65842322blot
blub85324872blub
blue65328462blue
bluet75631192bluet
blunt75525022blunt
blur66020532blur
blurt77625622blurt
bout66353292bout
brut66537962brut
but55963022_but
clot66542422clot
clout75330462clout
club85819472club
clue65324532clue
cult66541152cult
cut57957662_cut
daut56443562daut
elute54822572elute
englut738452englut
flat77147822flat
flit76539272flit
flout86226202flout
flu66530212flu_
flub95721882flub
flue75329852flue
flus75626542flus
flute86823752flute
fluty114415642fluty
flux145617742flux
fluyt114614202fluyt
gait56150192gait
gamut8322982gamut
gast56052562gast
gat46880512g_at
gaud67025432gaud
gault65128482gault
gaum75726422gaum
gaun56427712gaun
gaunt65430402gaunt
gaur56723352gaur
gelt56448012gelt
gent56954392gent
gest56149132gest
get47467462g_et
geum75424552geum
ghat86435282ghat
ghaut95919432ghaut
gift86735792gift
gilt56348542gilt
girt56646422girt
gist56046762gist
git46266052g_it
glad65624012glad
glam76529342glam
gled65631142gled
glee55239062glee
gleet65532342gleet
gleg66219802gleg
glen56027202glen
gley85724652gley
glia56423152glia
glib79421442glib
glim76026352glim
glint66830182glint
glitz154916372glitz
gloat65427682gloat
glob76623392glob
glom75424382glom
glop76724632glop
glost65422932glost
glouts74414712glouts
glow85222522glow
glued75118362glued
gluer65116772gluer
glues65125682glues
gluey95715262gluey
glugs75214282glugs
glume85120462glume
glums84621422glums
gluon6311222gluon
glutei7409742glutei
gluten74210752gluten
glutes74517672glutes
gnat56034432gnat
gnu45522042gnu_
gnus56518002gnus
goat56250832goat
got49870442g_ot
gouts64826172gouts
gouty95217362gouty
grat55651282grat
grit55247242grit
grot55942052grot
grout65330422grout
grub77220082grub
grue55825712grue
grum75625082grum
grunt65523542grunt
gul45832792g_ul
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
gum67439532g_um
gun47240802g_un
gust55240702gust
guts56637252g_uts
guv74523172g_uv
guy75728942g_uy
haut75949732haut
hut66457292_hut
iglu510814782iglu_
iglus6609932iglus
jut105944012_jut
klutz1868852klutz
lat37593402_lat
let36481472_let
lit39377312_lit
lot38179262_lot
lout45952142lout
lug46138062_lug
lum55542932_lum
lunt46148842_lunt
lust47442602_lust
lute46341012_lute
lutz136826322_lutz
luv67125772_luv
lux106528772_lux
maut65448452maut
mut58357182_mut
nut36651962_nut
out38072152_out
phut96925972phut
plat66048872plat
plot66141232plot
plug74915992plug
plum85122102plum
plus66324832plus
pout65752552pout
put55759072_put
rout46153282rout
rut35560522_rut
scut65835542scut
shut76137592shut
slat46959022slat
slit46250102slit
slot46049832slot
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
sluts54523982sluts
smut66629782smut
taut47048962taut
tout46753822tout
tut36758092_tut
ulu36028702ulu_
ulus45622562ulus
ut28647032__ut

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.266671770.7
2DLD Change Limit298721780.83035990.4
3Display Results1781780.0305933.3
 (SQL Overall)1786911781.126158695.4
 
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.