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

209 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
bigamy143634(None) 
digamy1335891digamy
beamy126218572b_eamy
bialy105119322bi_aly
biggy124413132big_gy
bigly114814752big_ly
binary11312222binary
gamy105427532__gamy
oogamy1235632oogamy
pigmy13299432pig_my
abigail1044193abigail
agama85815583_agama
angary10311323angary
apogamy1543623apogamy
baby116723683b__aby
bagass938933bagass
baggy125615683bag_gy
bagman114613813bagman
balmy125217473b_almy
bam78560143b__am_
bams87044453b__ams
barmy125218763b_army
bay89661643b__a_y
bayamo1335603bayamo
beady114719923b_eady
beaky146118023b_eaky
beam86939233b_eam_
beams95328173b_eams
became123213163became
bedamn1137813bedamn
begall92610723begall
began86319573bega_n
begat86629723bega_t
begaze1838333begaze
beggary14316153beggary
begum105213923begum_
begums11429493begums
beigy111110583beig__y
belady12489933belady
belay105021523bela_y
bename103316073bename
biali73419073bi_ali
bialys11387913bi_alys
bias64738163bi_a_s
bicarb1238543bicarb
biddy124612693bi_ddy
biface1358103biface
biffy164711133bi_ffy
big67345723big___
bigamies1337373bigamies
bigamist1347063bigamist
bigamous1385503bigamous
bigeminy1642903bigeminy
bigeye1236643bigeye
bigger104315063bigger
biggety1434433biggety
biggie103810933biggie
biggin103710603biggin
biggity1435013biggity
bight118728843big_ht
bights124417963bights
bigos85020013big_os
bigot84828323big_ot
bigotry1344523bigotry
bigots95015133bigots
bigs76235023big__s
bigtime1235753bigtime
bigwig1333343bigwig
bilby124912353bi_lby
bilgy114713713bi_lgy
biliary1238213biliary
billy105525363bi_lly
bima86723833bi__ma
bimah127013273bima_h
bimahs13508303bimahs
bimas95521743bima_s
binal75323823bina_l
binate8419773binate
biogas94310913bioga_s
biogeny1336023biogeny
biome94916993bi_ome
bionomy1444723bionomy
biopsy1334533biopsy
bipack1636523bipack
biparty1445583biparty
bireme10310143bireme
bitchy16479203bitchy
bitmap1235613bitmap
bitsy104511303bi_tsy
bitty106119173bi_tty
blam86131703b_lam_
blame95625493b_lame
blams95023853b_lams
bleary115112553bleary
blighty16356843blighty
blimy125212823b_limy
bloomy134510113bloomy
bogan87519003boga_n
bogans95714813bogans
bogart9617193bogart
bogey115220233bog_ey
boggy126116073bog_gy
bogy106426193bog__y
boomy125421823b_oomy
bosomy13509033bosomy
botany1139263botany
braggy13337173braggy
braky145015813b_raky
braxy175410893b_raxy
bray95232903b_ra_y
bready124511183bready
bream95121813bream_
breams104815043breams
briary114912003briary
brigade1136493brigade
brigand1136643brigand
broomy13449953broomy
buggy124613483bug_gy
byname13256363byname
byway1647533bywa_y
cigar8911803ciga_r
cigars9910723cigars
creamy134811363creamy
degame102713183degame
degami10279013degami
diary95016973di_ary
digamma1343103digamma
diram84419473diram_
dirams94413703dirams
dismay12229473dismay
dreamy12509993dreamy
eighty133711603eighty
exogamy2042803exogamy
filmy136114043fi_lmy
flamy135217473_flamy
foamy135313203_foamy
gaby107123193__gaby
gam67060063__gam_
gama77035523__gama
gamay116419113__gamay
gamb96331843__gamb
game76644323__game
gamey115320553__gamey
gammy135514893__gammy
gamp98833213__gamp
gams76648883__gams
gapy106320913__gapy
gay76856493__ga_y
giga66720943giga__
gigas75415583giga_s
giggly12518703giggly
gleamy12398113gleamy
highly1636823highly
iamb86623733_i_amb
imam81718333_imam_
imams91511113_imams
immy114611833_i_mmy
infamy1435653infamy
isogamy1343993isogamy
jicama1734883jicama
jiggly18378713jiggly
jiggy17549143jig_gy
jimmy19538503ji_mmy
legacy1256653legacy
ligan67920283liga_n
ligand85011293ligand
ligans76817733ligans
ligase7259913ligase
ligate72519253ligate
limy95727713li__my
lingam95112353lingam_
lingams104510193lingams
litany939053litany
loamy105913343_loamy
mighty154310213mighty
milady1236613milady
misogamy1644083misogamy
niggly11418913niggly
nighty135611273nighty
nizam16310253nizam_
nizams1735413nizams
ogam75120033_ogam_
ogams84112683_ogams
origami1045453origami
piggy124011433pig_gy
pigsty1235933pigsty
piracy1339473piracy
pygmy16334223pyg_my
righty135011833righty
rimy96621283ri__my
seamy105921273_seamy
sigma84513833sig_ma
sigmas94111363sigmas
steamy115112373steamy
sugary1039013sugary
swamy136714403_swamy
syngamy1643113syngamy
vagary1337333vagary
viga85622963viga__
vigas94817883viga_s
vivary1536983vivary
wigan95114393wiga_n
wigans104511703wigans
wiggly14559683wiggly
wiggy134510733wig_gy
wigwam1544723wigwam_
wigwams1643883wigwams
ziram163912893ziram_
zirams17438643zirams

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162095.20321663.7
3Display Results2092090.0633317.5
 (SQL Overall)1786912095.63931688.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.