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

40 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
gynecia138423(None) 
gynaecia1442361gynaecia
gynecic1584351gynecic
gynoecia1442461gynoecia
gynaecea1451292gynaecea
gynecium1642852gynecium
gynecoid1543932gynecoid
aecia73819283__aecia
agenesia945983agenesia
amnesia938293amnesia
anemia82613573_anemia
dynein1035563dyne_in
ganglia946613ganglia
genera71211713gene_ra
generic101310753generic
genesis82510823genesis
genetic101211783genetic
geneva1085853gene_va
gesneria944053gesneria
godetia945353godetia
gonia64117533gon__ia
gonidia975903gonidia
gymnasia1442983gymnasia
gynaecium1751923gynaecium
gynoecium1752073gynoecium
hymenia1546393hymenia
monecian1247283monecian
mycelia1444843mycelia
pyaemia1445733pyaemia
pyemia1337553py_emia
pyrexia19225463pyrexia
seneca839793senec_a
senecio947203senecio
synectic1546333synectic
synergia1243873synergia
synesis1039163synesis
synovia1345533synovia
uncia75015163_un_cia
zoecia1735553_zoecia
zooecia1843843zooecia

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 Filter1786911340270.423422437.4
2DLD Change Limit134027406.09321996.9
3Display Results40400.0162500.0
 (SQL Overall)178691406.53227356.2
 
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.