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 “oogamies” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
oogamies114741(None) 
apogamies1445322apogamies
bigamies1337372bigamies
digamies1238642digamies
exogamies1964572exogamies
hologamies1645872hologamies
homogamies1845972homogamies
isogamies1245412isogamies
monogamies1546192monogamies
oogametes12174632oogametes
oogamous1144792oogamous
oogenies9311582oogenies
agamids11317013_agamids
allogamies1345453allogamies
amies76837693___amies
angaries9314393angaries
autogamies1345573autogamies
bogies94724313bog__ies
boogies103719013boog__ies
botanies10312853botanies
commies133718453co_mmies
covaries13413253covaries
degames113312623degam_es
degamis11268443degami_s
doggies103613023dog_gies
dogies85022253dog__ies
dopamines1446043dopamines
endogamies1444243endogamies
foamier12339003fo_amier
foamiest13289853fo_amiest
fogies104118063fog__ies
gabies93820733__gabies
gambes116318313__gambes
games86238553__gam_es
gamier93617933__gamier
gamiest102816223__gamiest
gamines103618463__gamines
gamins94420043__gamins
goalies8316023go_alies
googlies1086763goog_lies
gouramies1294763gouramies
hoagies112811993ho_agies
hogmanes1446783hogmanes
hogties112813993hog_ties
homies114524723ho__mies
infamies1346683infamies
legacies1139043legacies
loamier9349163lo_amier
loamiest102310203lo_amiest
mamies104626243__mamies
misogamies1545263misogamies
moggies113111723mog_gies
mommies103912273mo_mmies
noogies82814583noog__ies
notaries8314933notaries
ogams84112683_ogam__s
ologies8615023olog__ies
oogamete11184933oogamete
oogamy1235633oogam__y
oologies9312993oologies
ooralis7312553oorali_s
organdies1187213organdies
organics1146383organics
organise939323organise
organises1048683organises
organizes1948753organizes
orgies72316093org__ies
origamis1145283origami_s
orogenies10410533orogenies
ostomies10310583ostomies
ovaries10312653_ovaries
pigmies122610993pig_mies
pogies94123543pog__ies
polygamies1885843polygamies
pommies133712843po_mmies
pygmies15205673pyg_mies
ramies84630463__ramies
roadies83317443ro_adies
rolamites1148243rolamites
roomies93017243ro_omies
rosaries8312783rosaries
rotaries8315693rotaries
sodamides1344653sodamides
sodomies11128553sodomies
swamies123712063_swamies
syngamies1544643syngamies
toadies82914863to_adies
tommies113812983to_mmies
vagaries12310293vagaries
votaries11312013votaries
xenogamies2053273xenogamies
zoogametes2252433zoogametes
zoogenies1946833zoogenies
zootomies2046143zootomies

Search took 8 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.1731032896.0
2DLD Change Limit146162946.93621073.0
3Display Results94940.0462043.5
 (SQL Overall)178691947.15524974.3
 
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.