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

62 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
eugenia84771(None) 
eugenias947141eugenias
eugenic1038601eugenic
eugenical1245062eugenical
eugenics1146582eugenics
eugenist949622eugenist
eugenol844622eugenol
euglena843952euglen_a
euglenid1074372euglenid
agenda837253_agenda
augend837633augen_d
augends935883augends
begonia1047213begonia
bumelia1145263bumelia
duenna734593du_enna
ecumenic1484823ecumenic
edenic9310223e_denic
egesta7428653e_gesta
eirenic939003eirenic
encaenia1044303encaenia
epigenic1347483epigenic
erogenic111110543erogenic
eudemonia1263243eudemonia
eugenists1046173eugenists
eugenols944623eugenols
euglenas943613euglenas
euglenids1173373euglenids
euglenoid1152793euglenoid
eulogia846663eulogia
eupepsia1243353eupepsia
euphenic1557203euphenic
eupnea835033eu_pnea
eupneic1144483eupneic
eureka1034483eure_ka
euxenite1545443euxenite
genial74917613__genial
genic85119393__genic
genie66124923__genie
genii64514173__genii
genip84415203__genip
genoa64315823__genoa
genua64614153__genua
gonia64117533__gonia
hymenia1546393hymenia
leucemia1263123leucemia
leukemia1462863leukemia
logania847833logania
lugeing9359113lugeing
magenta1038623magenta
oogonia846483oogonia
pogonia1048933pogonia
pudenda1142963pudenda
splenia948313splenia
sthenia1058503sthenia
taenia6313193_taenia
tenia55324483__tenia
ungenial946973ungenial
urania62516123_urania
uredia73610063_uredia
uremia82910893_uremia
weigelia1242213weigelia
xenia124814773__xenia

Search took 10 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.1561145455.1
2DLD Change Limit134027629.42314223.4
3Display Results62620.0163875.0
 (SQL Overall)178691629.59518623.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.