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

68 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
oogonia84648(None) 
oogonial945251oogonial
pogonia1048931pogonia
begonia1047212begonia
gonia64117532__gonia
logania847832logania
oogonium1144732oogonium
pogonias1148512pogonias
pogonip1245372pogonip
agonic93515143_agonic
ammonia1148693ammonia
aphonia122711883aphonia
ascogonia1253233ascogonia
atonia63816513_atonia
begonias1146263begonias
bignonia1144233bignonia
boltonia1045513boltonia
boronic11311163boronic
bosonic1139213bosonic
cogon89120903cogon__
cogons96818113cogon_s
coloni85619203coloni_
colonial10411343colonial
colonic115015713colonic
corona83817403coron_a
eugenia847713eugenia
gonif94320923__gonif
goonie73615563go_onie
gorgonian1142753gorgonian
hormogonia1653173hormogonia
isogonic11187253isogonic
loggia8457053log_gia
logia68116603log__ia
logoi69715943logo_i_
logon615922313logon__
logons79818173logon_s
loonie64216453lo_onie
mahonia1238443mahonia
moronic11311863moronic
myotonia1346273myotonia
obconic1346353obconic
ongoing938793ongoing
oogenies9311583oogenies
oogeny10117923oogen_y
oogoniums1243753oogoniums
oologic1049423oologic
oolong738073oolon_g
oolongs845953oolongs
opsonic1137253opsonic
opsonin946013opsonin
organa789213organ_a
organic1038313organic
organza1793463organza
orgone71110913orgon_e
orgones81010793orgones
orogenic11109363orogenic
ovonic11288183_ovonic
ozonic17308943_ozonic
pogonips1344383pogonips
somoni8310743somoni_
sporogonia1352803sporogonia
syconia1248313syconia
toonie63617993to_onie
valonia1048303valonia
yogini10449143yogini_
yoginis11457683yoginis
zoogenic2045973zoogenic
zoomania1945113zoomania

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 Filter1786911340270.406440125.6
2DLD Change Limit134027686.80019709.9
3Display Results68680.0135230.8
 (SQL Overall)178691687.21924752.9
 
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.