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

120 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
digamies123864(None) 
bigamies1337371bigamies
degames113312622degam_es
degamis11268442degami_s
diamides1238822di_amides
diamines11311642di_amines
diamins10312212di_amins
diaries83321952di_aries
digamist1248212digamist
digamists1345002digamists
digammas1443002digammas
digamous1296062digamous
oogamies1147412oogamies
pigmies122610992pig_mies
agamids11317013_agamids
amies76837693___amies
angaries9314393angaries
apogamies1445323apogamies
bialies93618413bi_alies
bigamist1347063bigamist
bigamists1444523bigamists
bigamous1385503bigamous
biggies113813523big_gies
binaries10314183binaries
dames85435853d__am_es
dataries9314033dataries
davies105020513d__avies
dearies83526273d_earies
defames132812253defam_es
degame102713183degam_e_
degami10279013degami__
degases93413103dega_ses
degasses10278363degasses
demies94825803d__emies
diacids1137863di_acids
diamide1138473di_amide
diamin9312523di_ami_n
diamine10311983di_amine
diapirs10347643di_apirs
diazines1838713di_azines
diazins1739183di_azins
dicambas1553793dicambas
dichogamies2053023dichogamies
dickies143416343di_ckies
diddlies1137593diddlies
didies84621833di__dies
didynamies1752463didynamies
dietaries10410663dietaries
digamma1343103digam_ma
digamy1335893digam__y
digitizes2046923digitizes
digits84114533dig__its
dignifies1446363dignifies
dignities1149593dignities
digoxins1744293digoxins
dilates83220663dila_tes
dillies84122163di_llies
dimes85833043di__m_es
dimities11314003dimities
dinghies1347363dinghies
dingies93618243di_ngies
dinkies123716033di_nkies
dioecies1138933dioecies
dipodies1238413dipodies
dirams94413703diram__s
dirties83119383di_rties
disables11410903disables
dismes95617673di_sm_es
dismiss1038153di_smiss
dittanies1045733dittanies
ditties83116983di_tties
divvies1457663di_vvies
dizzies16279753di_zzies
doggies103613023dog_gies
dogies85022253dog__ies
dopamines1446043dopamines
dreamier11287293dreamier
dreamiest12227223dreamiest
drearies92313413drearies
dummies123012133d_ummies
dynamics1644093dynamics
dynamites1544623dynamites
eighties12710803eighties
endogamies1444243endogamies
exogamies1964573exogamies
gabies93820733__gabies
gambes116318313__gambes
games86238553__gam_es
gamier93617933__gamier
gamiest102816233__gamiest
gamines103618463__gamines
gamins94420053__gamins
gigabits1243533gigabits
gimmies123010113gi_mmies
immies102412443_i_mmies
infamies1346683infamies
isogamies1245413isogamies
jimmies18328783ji_mmies
legacies1139043legacies
ligases82310713liga_ses
ligates82318383liga_tes
litanies8310993litanies
mamies104626243__mamies
miladies1139923miladies
misogamies1545263misogamies
nighties121011383nighties
origamis1145283origami_s
piggies113813483pig_gies
pigsties1139783pigsties
piracies12312643piracies
pygmies15205673pyg_mies
ramies84630463__ramies
righties12711573righties
siganids1045303siganids
swamies123712063_swamies
syngamies1544643syngamies
vagaries12310293vagaries
vitamines1446553vitamines
vitamins1347083vitamins
vivaries1439263vivaries

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621207.61019206.6
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.06222164.6
 
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.