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

161 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
gym9571906(None) 
gam67060061gam
gem66840221gem
gum67439531gum
gyms107514591gyms
gyp98319011gyp
aim57858212aim
am411875562_am
arm58449622arm
ay511773892ay_
aye67151762aye
ays67050292ays
bam78560142bam
bum75342692bum
by77529232by_
bye86134592bye
bys85229462bys
cam78058982cam
cum76440162cum
cwm106815082cwm
cyma116715842cyma
cyme119420372cyme
dam67457042dam
dim68146492dim
dom69752442dom
dye75334842dye
elm57531742elm
em49445152_em
eye65539772eye
fem86040732fem
gab67155992gab
gad57556652gad
gae46457702gae
gag57753632gag
gal46055512gal
gama77035522gama
gamb96331842gamb
game76644322game
gamp98833212gamp
gams76648882gams
gamy105427532gamy
gan48060132gan
gap67055612gap
gar47259902gar
gas48870252gas
gat46880512gat
gaum75726422gaum
gay76856492gay
gays87338022gays
ged57044532ged
gee45359202gee
gel45642432gel
gems75329112gems
gen45950512gen
germ75428962germ
get47467462get
geum75424552geum
gey75738302gey
ghi77019882ghi
gib66443532gib
gid57047262gid
gie47149542gie
gig56040752gig
gimp96124042gimp
gin46055752gin
gip67645362gip
git46266052git
glam76529342glam
glim76026352glim
glom75424382glom
glum75825102glum
gnu45522042gnu
go38748742g_o
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gor47848262gor
gorm75529392gorm
gos47155132gos
got49870442got
gox117137182gox
goy77844552goy
goyim1148602goyim
goys86328412goys
gram77034582gram
grim76929422grim
grum75625082grum
gul45832792gul
gums75030942gums
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
guys85019642guys
gybe105916242gybe
gyps105115022gyps
gyre84722762gyre
gyri85415152gyri
gyro85217882gyro
gyve116215082gyve
ham86363282ham
hem86148732hem
him86247662him
hm78126732_hm
hmm106218992hmm
hum85542932hum
hymn12311312hymn
hyp117822462hyp
ism56322382ism
jam126942522jam
kye107327272kye
lam57666712lam
lum55542932lum
lye66533412lye
mem77943472mem
mim76048422mim
mm67826812_mm
mom78853162mom
mum76643612mum
my78125652my_
myc106519502myc
nam55953392nam
nim57142952nim
nom510450642nom
ogam75120032ogam
ohm86523012ohm
om48553002_om
oy58950132oy_
pam77858392pam
pom78249912pom
pya87023752pya
pye86432502pye
pyx157817012pyx
ram56867272ram
rem56150042rem
rim56052272rim
rom59855632rom
rum56644642rum
rya67622012rya
rye66032542rye
sim56553142sim
som59153812som
sum56346012sum
syn67024122syn
tam58663422tam
tom514358052tom
tye65837442tye
um47338832_um
umm711921262umm
vim87437022vim
vum85428652vum
wye96331972wye
wyn95921442wyn
ya510251502_ya
yam87448992yam
ye57650062_ye
yo59748552_yo
yom88043442yom
yum86132822yum
zyme1819114942zyme

Search took 1 second 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 Filter178691140840.0602978183.3
2DLD Change Limit140841610.33042678.8
3Display Results1611610.0305366.7
 (SQL Overall)1786911610.420425454.8
 
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.