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

254 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
gally95026172gally
gilly94321632gilly
gley85724652g_ley
golly95121102golly
gulfy124612002gulfy
gully94020682gully
gulpy114612762gulpy
ably99725133abl_y
agley96917333agley
agly86821803agl_y
alky115920343_alky
allay85620393allay
alley85721673alley
alloy85519973alloy
ally76935643_ally
axle116424603axl_e
axled135315813axled
axles125219473axles
baldy115518933baldy
balky145418243balky
bally105530103bally
balmy125217473balmy
belay105021523belay
belly104625493belly
bilby124912343bilby
bilgy114713713bilgy
billy105525363billy
bulgy115214103bulgy
bulky146215573bulky
bully105124813bully
clay95927413_clay
cloy96623833_cloy
colby124415063colby
colly104926773colly
coly96940533col_y
cully105520463cully
dally95324743dally
delay94820633delay
delly96023873delly
dilly94923783dilly
dolly96125203dolly
dully94921633dully
duly85323033dul_y
eely77725213eel_y
elmy95616793_elmy
felly114922803felly
filly114424903filly
filmy136114043filmy
flay106332803_flay
fley106626853_fley
fly97124953_fl_y
foley115222303foley
folky159214713folky
folly115022603folly
fully114820863fully
gabby135512943gabby
gaby107123193g_aby
gaily95020973gaily
gal46055513gal__
gala55635163gal_a
galah95917623galah
galas65731643galas
galax135314463galax
galaxy17476313galaxy
gale56347323gal_e
galea64722933galea
gales65442483gales
gall56335993gal_l
galley104215453galley
galls64729323galls
galop84716213galop
gals57946503gal_s
gamay116419103gamay
gamey115320553gamey
gammy135514893gammy
gamy105427533g_amy
gappy136212033gappy
gapy106320913g_apy
gassy95514023gassy
gaudy106611463gaudy
gauzy18489213gauzy
gawky16569993gawky
gawsy12459093gawsy
gay76856493g__ay
gayly124513093gayly
geeky134710733geeky
gel45642433gel__
geld65828433gel_d
gelds75118343gelds
gelee63626983gelee
gelid74916973gelid
gels56836103gel_s
gelt56448013gel_t
gelts65924613gelts
gemmy135211053gemmy
germy115113663germy
gey75738303g__ey
giddy115810203giddy
gild65526513gil_d
gilds75417523gilds
gill56336183gil_l
gills64728193gills
gilt56348543gil_t
gilts64924263gilts
gimpy135212233gimpy
ginny95314573ginny
gipsy11579543gipsy
girly94415293girly
glad65624013g_lad
glady105413943glady
glam76529343g_lam
glary96018543glary
glazy187410983glazy
gled65631143g_led
glee55239063g_lee
gleg66219803g_leg
glen56027203g_len
gleys96514853g_leys
glia56423153g_lia
glib79421433g_lib
glim76026353g_lim
glob76623393g_lob
glom75424383g_lom
glop76724633g_lop
glory96413293glory
glow85222523g_low
glue55628493g_lue
gluey95715263gluey
glug66118013g_lug
glum75825103g_lum
glut56331293g_lut
goby106021083g_oby
godly104913293godly
gold65430163gol_d
golds75421313golds
golem8416113golem
golf85731183gol_f
golfs95616103golfs
goody105620393goody
gooey95522863gooey
goofy124915623goofy
gooky135818033gooky
goony95519783goony
goopy115816623goopy
goosy96018883goosy
gorsy95915783gorsy
gory86129663g_ory
gouty95217363gouty
goy77844553g__oy
grapy115416433grapy
gravy125512113gravy
gray85329893g_ray
grey85624043g_rey
grimy114312603grimy
gripy115115253gripy
grody103412063grody
guilty10418233guilty
gul45832793gul__
gulag7310823gulag
gular6314833gular
gulch113810603gulch
gules64831043gules
gulf84929423gul_f
gulfs94915303gulfs
gull54828453gul_l
gulley104213163gulley
gulls65222983gulls
gulp75521363gul_p
gulps84715073gulps
guls55930853gul_s
gummy135413653gummy
gunky135514113gunky
gunny94413663gunny
guppy135211273guppy
gurry94515413gurry
gushy125213123gushy
gussy95314323gussy
gusty95119573gusty
gutsy96412843gutsy
gutty94516993gutty
guy75728943g__uy
gypsy14636993gypsy
hilly114422163hilly
holey115626903holey
holly114824433holly
holy106333433hol_y
hulky155312473hulky
idly85617323idl_y
illy76925333_illy
inlay85214323inlay
inly75622213inl_y
jelly154218253jelly
jolly154517513jolly
jolty155713033jolty
kelly124617023kelly
kelpy145110683kelpy
kilty125213893kilty
laxly15610103laxl_y
lay68865353__lay
ley66246813__ley
lily76730183lil_y
lolly85120663lolly
malmy124816343malmy
malty106721703malty
melty104918363melty
milky144014443milky
milty104720073milty
moldy115014653moldy
molly105222493molly
moly96031913mol_y
muley104819283muley
nelly84618813nelly
oily77932253oil_y
oldy85316843_oldy
onlay84212943onlay
only75319723onl_y
oxlip1456883oxlip
oxy136320983ox__y
pally105727123pally
palmy126016733palmy
palsy105417463palsy
paly95835533pal_y
pily96132733pil_y
play95928983_play
ploy96123603_ploy
ply86323553_pl_y
poly96235153pol_y
pulpy124612363pulpy
rally84725903rally
relay84424673relay
rely75428953rel_y
riley84420583riley
ruly76323143rul_y
sally85129713sally
salty85524383salty
silky125315823silky
silly84527613silly
silty84721633silty
slay76436383_slay
sly66228563_sl_y
splay105816043splay
sulky124715363sulky
sully84622893sully
talky126215683talky
tally84526863tally
telly84920823telly
ugly86012383ugl_y
unlay84613703unlay
wally114625093wally
waly105830903wal_y
welly114620013welly
willy115321913willy
wily106428813wil_y
yolky15529523yolky

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836672544.00020916.8
3Display Results2542540.0634031.7
 (SQL Overall)1786912544.17342820.8
 
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.