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 “guglets” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

389 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
guglets936969(None) 
giglets93211551giglets
goglets9379781goglets
guglet84018221guglet_
gullets84013711gullets
gurglets10355541gurglets
aglets73915682_aglets
aiglets84012912aiglets
auklets11298572auklets
buglers105115322buglers
bugles94822442bugle_s
bullets93516392bullets
culets85518512cu_lets
cullets94015612cullets
cutlets94113652cutlets
eaglets84111662eaglets
fugles104715782fugle_s
gallets83517402gallets
giblets103210422giblets
giglet83920272giglet_
giglots9367862giglots
gimlets10338432gimlets
goblets103210182goblets
goglet84618582goglet_
guggles103410542guggle_s
guiles73919282guile_s
guilts74111232guil_ts
gules64831042gu_le_s
gullet74924832gullet_
gulleys11438522gulleys
gumless10228272gumless
gunless8299632gunless
gurgles94312872gurgle_s
gurglet94412032gurglet_
gurnets84010792gurnets
gussets837442gussets
gutless82610712gutless
mullets93614782mullets
nuggets936382nuggets
nutlets74111252nutlets
outlets73616362outlets
piglets103311792piglets
pullets94015162pullets
reglets83512982reglets
runlets73310772runlets
sublets92616702sublets
tugless837382tugless
wiglets113411422wiglets
aglet65534143_aglet_
aiglet74224193aiglet_
aigrets82810533aigrets
amulets939923amulets
anglers84014823anglers
angles74426703angle_s
anklets114310413anklets
applets115710063applets
argles75218483argle_s
armlets94610063armlets
augers73818703aug_ers
aughts104710243aug_hts
augites8312183augites
augments1137833augments
auklet104216833auklet_
baguets1037483baguets
ballets93719513ballets
begets96215523beg_ets
billets94516153billets
blets75324943__blets
bogles95020833bogle_s
buckets153811693buckets
budgets11489863budgets
budless1038873budless
buffets15317593buffets
buggers114315663buggers
bugle84721943bugle__
bugled104918133bugle_d
bugler94717723bugle_r
bugloss1035893bugloss
bugouts1036193bugouts
bulblets1255353bulblets
bulgers105215143bulgers
bulges95919323bulge_s
bullet84528613bullet_
bunglers11398483bunglers
bungles104116763bungle_s
burets84321263bu_rets
burgles105615963burgle_s
burlers94120273burlers
burleys12479673burleys
burnets93813263burnets
butlers94518053butlers
butles84423913butle_s
cablets114216343cablets
callets93821703callets
camlets114314623camlets
caplets114914523caplets
chalets122813473chalets
collets93517903collets
couplets12389873couplets
culet76040343cu_let_
cullers93418853cullers
cullet84727313cullet_
cults75022553cu_l_ts
curets84922343cu_rets
curlers94218073curlers
curlews12387393curlews
curvets12399913curvets
cutlers94217003cutlers
cutlet84924363cutlet_
cygnets1333813cygnets
diglots9299503diglots
doglegs1034783doglegs
doublets11257363doublets
druggets11313913druggets
duelers83412053duelers
duets65323883du__ets
dugouts935043dugouts
dulcets1046283dulcets
dullest8312633dullest
duvets1039223du_vets
eagles73819163eagle_s
eaglet73722583eaglet_
eggless935663eggless
egrets72712243_egrets
engluts834533engluts
euglena843953euglena
euglenas943613euglenas
eyelets1057523eyelets
filets94718953_filets
fillets103414753fillets
fogless1138193fogless
froglets1235263froglets
fuelers103912393fuelers
fugle94915543fugle__
fugled114813693fugle_d
fugues104511683fugue_s
fullers103817373fullers
fullest10313343fullest
fumets114311813fu_mets
furlers104214223furlers
furless103210143furless
gables94222333gable_s
gadgets10348683gadgets
gagers84021333gag_ers
gages74529973gag_e_s
gaggers103413663gaggers
gaggles103512593gaggle_s
galeas74618513g_aleas
gales65442483g_ale_s
gallet73630853gallet_
galleta8399643galleta
galletas9308133galletas
galleys11369713galleys
gannets83811443gannets
gantlets9308903gantlets
gaolers83511563gaolers
gapless10349993gapless
gargets94614573gargets
garglers10418263garglers
gargles94214893gargle_s
garnets84115403garnets
garrets84413623garrets
gaskets12348153gaskets
gasless8319013gasless
gaugers94211713gaug_ers
gauges85915993gaug_e_s
gaults74112783gaul_ts
gauntlets1042873gauntlets
gelees74116263g_elees
gelts65924613g_el_ts
genets75716663g_enets
gets55442483__g_ets
gibbets12417723gibbets
giblet93418893giblet_
gigglers11297403gigglers
giggles103312933giggle_s
giglot84013133giglot_
gigots83911953gig_ots
gigues8129003gigue_s
gillers84216903gillers
gillnets934733gillnets
gilts64924263g_il_ts
gimlet93716663gimlet_
gleds75417893__gleds
glees65027593__glees
gleets75315053g_leets
glens66519853__glens
gleys96514853__gleys
gluts66120133__gluts
gobbets12327643gobbets
goblet93219483goblet_
godets8410933g_odets
godless938403godless
gogglers11276713gogglers
goggles103510793goggle_s
golems939323g_olems
gorgets94711783gorgets
gougers94911763goug_ers
gouges86318693goug_e_s
gourmets1144153gourmets
greets75117423g_reets
grivets11357973grivets
gruelers936173gruelers
grummets13275033grummets
gudes74520813gu_de_s
guess64213363gu__ess
guest65225923gu__est
guests74311203gu_ests
guggle94110433guggle__
guggled11338563guggle_d
guiders94111113guiders
guides84118283guide_s
guilders1035513guilders
guilds8388353guil_ds
guile64521133guile__
guiled84315383guile_d
guilt65125573guil_t_
guilty10418233guil_ty
guineas836753guineas
guises74216313guise_s
gulags837543gu_lags
guldens9356573guldens
gulfs94915303gu_l_fs
gulled84521373gulle_d
gulley104213163gulle_y
gullies84717313gullies
gulls65222983gu_l_ls
gulpers10299013gulpers
gulps84715073gu_l_ps
guls55930853gu_l__s
gummers123712203gummers
gunites8313123gunites
gunnels8358563gunnels
gunners83111733gunners
gunsels8338133gunsels
gurges84716863gurge_s
gurgle83912473gurgle__
gurgled10399123gurgle_d
gurnet74920873gurnet_
gurneys11406463gurneys
gushers113512513gushers
gushes104719033gushe_s
gusset7316433gusset_
gustless9287683gustless
gusts65722793gu__sts
guts56637253gu___ts
gutters83715513gutters
guttlers9306933guttlers
guttles83011933guttle_s
guyots1036003gu_yots
guzzlers17274863guzzlers
guzzles16328043guzzle_s
hamlets123211403hamlets
haslets102510863haslets
hoggets12498323hoggets
howlets13329223howlets
hueless1058823hueless
hugest10311763hug_est
huggers124211593huggers
hullers103616263hullers
hurlers103714323hurlers
hurleys13407333hurleys
ingles74420873ingle_s
inlets63915573_inlets
islets64513083_islets
jagless1537103jagless
jugglers17366523jugglers
juggles164510843juggle_s
juleps1535623ju_leps
jungles154112543jungle_s
junkets18377623junkets
keglers12277773keglers
kinglets13318583kinglets
kugels1146073kug_els
legless838013legless
lets47147943___lets
loggets9378913loggets
lugers74617023lug_ers
luges65928753lug_e_s
luggers93713483luggers
lullers73213353lullers
lunets66914763lu_nets
maglevs1334693maglevs
magnets10311143magnets
mallets93318493mallets
millets94216843millets
muggees11338883muggees
muggers113611933muggers
mulcts10298713mu_lcts
mules75034293mu_le_s
muleta839233mu_leta
muletas937383mu_letas
muleys11409643mu_leys
mullens93611313mullens
mullers93217303mullers
mullet84126823mullet_
mulleys12299203mulleys
muskets13258643muskets
neglects1144383neglects
nucleus956573nucleus
nugget8311723nugget_
nuggety1234313nuggety
nutlet64220563nutlet_
oglers74313183_oglers
ogles65223183_ogle_s
omelets938333omelets
oughts104710183oug_hts
outlet63728683outlet_
outsets73514923outsets
owlets93110393_owlets
palets85122313_palets
pallets93919303pallets
pegless1038053pegless
pellets94014783pellets
piglet93420923piglet_
piolets93513193piolets
plugless1133863plugless
pugrees10218523pugrees
pulers83820283pu_lers
pules74538813pu_le_s
pullers93618483pullers
pullet84026333pullet_
pulleys12399143pulleys
pungles104013713pungle_s
punnets9409263punnets
puppets10317013puppets
pusleys12286233pusleys
queleas1636723queleas
quiets154014373qu_iets
quillets17256823quillets
quilts154112543quil_ts
reflets103513153reflets
reglet73724233reglet_
regrets83212923regrets
relets64025673_relets
riblets93412553riblets
rillets74216153rillets
ringlets92910233ringlets
rubles83921703ruble_s
ruggers94612313ruggers
rulers64317093ru_lers
rules55234253ru_le_s
rundlets9307363rundlets
rungless956733rungless
runless72810423runless
runlet63821413runlet_
russets738163russets
sallets73719653sallets
samlets93813553samlets
signets83311503signets
singlets93611473singlets
sniglets9276813sniglets
stylets10369213stylets
sublet82827243sublet_
sublots92410913sublots
subnets92512083subnets
subsets92813103subsets
suets55126103su__ets
suggest9310863suggest
suggests1044713suggests
sumless92611123sumless
sunkets113511283sunkets
sunless73013693sunless
sunsets72911573sunsets
sutlers73116973sutlers
tablets94714383tablets
toilets74112913toilets
tonlets73212503tonlets
tuckets134810333tuckets
tuffets13266523tuffets
tuggers93711443tuggers
tules54532793tu_le_s
tulles63218893tulle_s
turrets73010673turrets
uglies7412323_uglies
ugliest8410153_ugliest
unless62413073_unless
unlet54133333_unlet_
unsets64116163_unsets
upsets8409683_upsets
valets93715623_valets
varlets10411573varlets
violets102210003violets
wallets103914833wallets
wigless11359673wigless
wiglet105519153wiglet_
willets104414323willets
winglets12299593winglets
yules84521583yu_le_s

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273896.79619721.5
3Display Results3893890.1432720.3
 (SQL Overall)1786913897.34524328.3
 
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.