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 “gamey” 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
gamey11532055(None) 
gamay116419111gamay
game76644321game_
gamed95126391gamed
gamely124711911gamely
gamer84928941gamer
games86238551games
gammy135514891gammy
gamy105427531gam_y
mamey125418831mamey
agley96917332agley
amen66733152_amen
cagey115917822cagey
cakey145517272cakey
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
campy145116182campy
dame77140312dame_
dames85435852dames
fakey155515422fakey
fame95639392fame_
famed115928342famed
fames105735922fames
gabby135512952gabby
gaby107123192ga_by
gae46457702ga_e_
gaed66031512ga_ed
gaen57329602ga_en
gaes56348032ga_es
gage65936102gage_
gaged85522312gaged
gager74726292gager
gages74529972gages
gagmen103910412gagmen
gaiety10119372gaiety
gaily95020972gaily
gale56347322gale_
galea64722942galea
gales65442482gales
galley104215452galley
gally95026172gally
gam67060062gam__
gama77035522gam_a
gamas85431362gamas
gamays126310912gamays
gamb96331842gam_b
gamba106018512gamba
gambe106219212gambe
gambes116318312gambes
gambs105721122gambs
gamers94420832gamers
gamest94919932gamest
gamete9313592gamete
gamic103916202gamic
gamier93617932gamier
gamily123712182gamily
gamin84423002gamin
gamma106116102gamma
gammed124216162gammed
gammer1112318332gammer
gamp98833212gam_p
gamps105323712gamps
gams76648882gam_s
gamut8322982gamut
gane55145302gane_
ganef96322462ganef
ganev95513862ganev
gape75134512gape_
gaped96123532gaped
gaper86125122gaper
gapes86030822gapes
gappy136212032gappy
gapy106320912ga_py
garvey13127872garvey
gases65633992gases
gasmen93111562gasmen
gassy95514022gassy
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
gaudy106611462gaudy
gaumed104610322gaumed
gauzy18489212gauzy
gave84634052gave_
gavel95815182gavel
gawky16569992gawky
gawsy12459092gawsy
gay76856492ga__y
gayer94519192gayer
gayety13116382gayety
gayly124513092gayly
gaze145032412gaze_
gazed165520332gazed
gazer155720072gazer
gazes155425912gazes
gemmy135211052gemmy
gey75738302g__ey
gimel8313352gimel
gimpy135212232gimpy
gley85724652g_ley
gluey95715262gluey
gomer85220652gomer
gooey95522862gooey
grapey126012302grapey
grey85624042g_rey
gummy135413652gummy
hame97043132hame_
hames106138702hames
hammy155113432hammy
hayey144812532hayey
homey135924842homey
jammy194810192jammy
kame105728232kame_
kames115024692kames
lacey105820912lacey
lamby125114842lamby
lame66849292lame_
lamed85235292lamed
lamely114013222lamely
lamer75233702lamer
lames75445542lames
limey104721042limey
mameys13449522mameys
mammey124310892mammey
mammy115215162mammy
matey107022662matey
name65637412name_
named85223062named
namely113711322namely
namer75622102namer
names74833362names
pacey126720282pacey
ramee74633852ramee
ramen75625192ramen
ramet75743142ramet
rammy124312492rammy
same65245642same_
samek114915272samek
tame66343662tame_
tamed85528512tamed
tamely113711952tamely
tamer75230102tamer
tames75242012tames
tammy124013222tammy
vampy15539402vampy
wame95035482wame_
wames106432802wames
waney115120322waney
wavey145115542wavey
yamen104115182yamen
yawey14458272yawey

Search took 3 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.360496363.9
2DLD Change Limit538001541.62333148.5
3Display Results1541540.0463347.8
 (SQL Overall)1786911542.02988068.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.