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

58 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
gonidia97590(None) 
conidia1069301conidia
gonidial1065941gonidial
gonidic1166101gonidic
conidial1159502conidial
conidian1168382conidian
gonadial1066822gonadial
gonadic1177212gonadic
gonia64117532gon__ia
gonidium1244212gonidium
oidia6314952_o_idia
accidia1246993accidia
aecidia1047283aecidia
ascidia1046683ascidia
basidia1047613basidia
bolivia1246063bolivia
bonita8312943boni_ta
cnida878953_cnid_a
coccidia1244013coccidia
comitia1139723comitia
conidium1366643conidium
ctenidia1143013ctenidia
ganglia946613ganglia
genii64514173geni_i_
giardia945563giardia
glochidia1652263glochidia
gloxinia1642693gloxinia
gobioid1146023gobioid
godetia945353godetia
gonad75216053gonad__
gonadal956523gonadal
gonads84511733gonad_s
gondola946663gondola
gonif94320923gon__if
goniff13408893goni_ff
goniffs14473903goniffs
gonifs104310133goni_fs
gonion73612833goni_on
gonium949803goni_um
goodie83613993go_odie
gordita945093gordita
gorilla836973gorilla
guanidin1044193guanidin
gynecia1384233gynecia
honda9414983hon_d_a
monadic1268883monadic
monodic1269783monodic
nidi56524403__nidi_
nonideal947303nonideal
oxidic1635943_oxidic
peridia10312363peridia
podia8415283po__dia
pycnidia1642873pycnidia
pygidia1444193pygidia
pyxidia2043843pyxidia
solidi73813153solidi_
tolidin839243tolidin
tondi65716143ton_di_

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.406440125.6
2DLD Change Limit134027585.78023188.1
3Display Results58580.0331757.6
 (SQL Overall)178691586.21928733.1
 
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.