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

226 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
digamy133589(None) 
bigamy1436341bigamy
degame102713182degame
degami10279012degami
diary95016972di_ary
digamma1343102digamma
diram84419472diram_
dirams94413702dirams
dismay12229472dismay
dreamy12509992dreamy
gamy105427532__gamy
oogamy1235632oogamy
pigmy13299432pig_my
agama85815583_agama
angary10311323angary
apogamy1543623apogamy
beamy126218573_beamy
bialy105119323bi_aly
biggy124413133big_gy
bigly114814753big_ly
binary11312223binary
cigar8911803ciga_r
cigars9910723cigars
creamy134811363creamy
dam67457043d__am_
dame77140313d__ame
damn75724323d__amn
damp96228843d__amp
dams77444373d__ams
datary10310243datary
davy116015523d__avy
day76254113d__a_y
deary95826843d_eary
decamp1338453decamp
decay114718483deca_y
defame123212433defame
degage92711383degage
degames113312623degames
degamis11268443degamis
degas75119163dega_s
degum94711903degum_
degums10438623degums
delay94820633dela_y
demy105422853d__emy
denary105316863denary
deray95024183dera_y
diagram1147363diagram_
diagrams1246133diagrams
dial55935063di_a_l
dials64925343di_als
diamin9312523di_amin
diazo15310033di_azo
dicamba1453413dicamba
dicast9315573dicast
dicey114819333di_cey
dichogamy2152533dichogamy
dickey165913523dickey
dicky154816243di_cky
dicty115116293di_cty
didact10711203didact
diddly12389573diddly
didy99121513di__dy
didynamy1851423didynamy
dietary1158663dietary
dig57544473dig___
digamies1238643digamies
digamist1248213digamist
digammas1443003digammas
digamous1296063digamous
digest84019623digest
digged104314653digged
digger94616083digger
dight104027003dig_ht
dights114016963dights
digit73825273dig_it
digits84114533digits
diglot83014333diglot
dignify1543893dignify
dignity1236453dignity
digraph14146643digraph
digs66036053dig__s
dikey135116423di_key
dilate73220693dilate
dilly94923783di_lly
dim68146493di__m_
dime76237643di__me
dimity12310473dimity
dimly114913483di_mly
dimply14339743dimply
dims75435023di__ms
dinar66319893dina_r
dinars75417563dinars
dingey114914053dingey
dinghy14476963dinghy
dingily1238103dingily
dingy105721263di_ngy
dinkey144812763dinkey
dinkly144311083dinkly
dinky135819373di_nky
dioecy1235543dioecy
diorama1046533diorama
dipody1336363dipody
dippy135111543di_ppy
direly10311563direly
dirham12378273dirham_
dirhams13376313dirhams
dirty95617803di_rty
disarm9310473disarm
disarms1039043disarms
dishy125712353di_shy
dismal92412243dismal
dismays13237433dismays
disme85716243di_sme
dita56032523dita__
ditas65923673dita_s
ditsy95612563di_tsy
dittany1135653dittany
ditty95019293di_tty
ditzy186513283di_tzy
diva85920883diva__
divan96114843diva_n
divans104612393divans
divas95418583diva_s
divvy15356483di_vvy
diwan95712553diwa_n
diwans105110373diwans
dizzy177410853di_zzy
dogey105719513dog_ey
doggy115214873dog_gy
dogma96112463dog_ma
dogmas105011243dogmas
dogy96126493dog__y
doomy116018263d_oomy
dormy115817473d_ormy
draggy12346823draggy
dram75832003d_ram_
drama85117413d_rama
drams86025833d_rams
dray85428093d_ra_y
dream85120393dream_
dreams94513983dreams
dreamt94615713dreamt
dreary104611673dreary
dummy134712783d_ummy
dunam8313733dunam_
dunams937833dunams
dynamo1274163dynamo
eighty133711603eighty
endogamy1542983endogamy
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 7 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.406440125.6
2DLD Change Limit1127162265.72019705.6
3Display Results2262260.0762973.7
 (SQL Overall)1786912266.20228811.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.