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

79 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
aggadic125481(None) 
haggadic1643071haggadic
agamic113110562a_gamic
agaric93513632a_garic
aggada955222aggad_a
aggadah1362862aggadah
aggadas1055002aggadas
aggadot1045182aggadot
agnatic10310972agnatic
agravic1345892agravic
hagadic1445862hagadic
acidic113612133a_cidic
acmatic13311693acmatic
again65218123a_ga_in
agamid103710693a_gamid
agapeic1244713agapeic
agarics10319943a_garics
aggadahs1462263aggadahs
aggadoth1452053aggadoth
aggie73415013agg__ie
aggrade1035643aggrad_e
aggraded1244203aggraded
aggrades1135863aggrades
aggrading1344843aggrading
agnail739533agna_il
agonic93515143a_gonic
agraphic1646183agraphic
alcaic1039983alca_ic
alkalic13146973alkalic
amidic114012873a_midic
angaria8311583angaria
angelic1039623angelic
anodic92813133a_nodic
aphasic142810063aphasic
apogamic1545013apogamic
apraxic1846293apraxic
aquatic1838113aquatic
arabic10312733a_rabic
arcadia1039703arcadia
argali75013753argali_
argalis84214193argalis
argotic10310283argotic
asdic83814093a__sdic
astatic9514193astatic
atavic11189293a_tavic
ataxic15169203a_taxic
augitic1038283augitic
aviatic1239243aviatic
balladic1345333balladic
dryadic1443623dryadic
dyadic1336093_dyadic
ergodic1145503ergodic
faradic1337693faradic
gadi66329723__gadi_
gadid85517383__gadid
gadis74825293__gadis
gamic103916203__gamic
geodic1048003_geodic
gonadic1177213gonadic
gradin83517483_gradin
haggada1353643haggad_a
haggadah1762593haggadah
haggadas1463633haggadas
haggadist1543843haggadist
haggadot1444063haggadot
hexadic2045413hexadic
maenadic1344613maenadic
magmatic1548393magmatic
manganic1346993manganic
margaric1346063margaric
monadic1268883monadic
nomadic1248033nomadic
octadic1245713octadic
oghamic1544043oghamic
organic1038313organic
palladic1346113palladic
saccadic1244173saccadic
triadic1037833triadic
vanadic1336743vanadic

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 Limit134027795.83022989.2
3Display Results79790.0302633.3
 (SQL Overall)178691796.28328440.4
 
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.