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

96 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
agravic134589(None) 
agamic113110562ag_amic
agaric93513642ag_aric
aggadic1254812aggadic
agnatic10310972agnatic
agraphic1646182agraphic
apraxic1846292apraxic
arabic10312732a_rabic
atavic11189292a_tavic
gravid113710982_gravid
acmatic13311703acmatic
acrasia9310033acrasia
acrasin9311223acrasin
acronic112814693acronic
acrotic112515543acrotic
acrylic1496283acrylic
aerobic11310213aerobic
afraid1049723afra_id
again65218123ag_a_in
agamid103710693ag_amid
agapeic1244713agapeic
agarics10319943ag_arics
agave95314033ag_av_e
agaves104611513ag_aves
agnail739533agna_il
agonic93515143ag_onic
agrafe1038093agra_fe
agrafes1137523agrafes
agraffe1443333agraffe
agrapha1345133agrapha
agraphia1445243agraphia
agrarian948253agrarian
agrestic1147923agrestic
agria65517143agr__ia
akvavit1742943akvavit
alcaic1039983alca_ic
alkalic13146973alkalic
aortic8316613aor_tic
aphasic142810063aphasic
apractic1448303apractic
apraxia1646893apraxia
aprotic112715243aprotic
aquatic1838113aquatic
aquavit1945203aquavit
arabica1147283a_rabica
aramid93315613a_ramid
arctic10313513a_rctic
areic73219393a_r_eic
argali75013753argali_
argalis84214193argalis
argotic10310283argotic
astatic9514193astatic
ataraxic1743923ataraxic
ataxic15169203a_taxic
atresic9310003atresic
atretic9313923atretic
auric74521743aur__ic
aviatic1239243aviatic
boracic1338723boracic
bravi104715753_bravi_
ceramic1339823ceramic
erratic9311123erratic
faradic1337693faradic
gamic103916203_g_amic
garlic9310043gar_lic
gradin83517483_gradin
grail64622873_gra_il
grain65126253_gra_in
graphic1537353_graphic
gratin74520583_gratin
gratis74819243_gratis
grave94624873_grav_e
graved114818813_graved
gravel105313823_gravel
graven104513523_graven
graver105018593_graver
graves104624003_graves
gravida12366563_gravida
gravies11314093_gravies
graving123114563_graving
gravity1437183_gravity
gravy125512113_grav_y
hagadic1445863hag_adic
haggadic1643073haggadic
keramic1537233keramic
magmatic1548403magmatic
margaric1346073margaric
oghamic1544043oghamic
organic1038313organic
piratic11314293piratic
puranic11410483puranic
rabic93817403__rabic
ravin85624653__ravin
tragic93811553_tragic
uranic82315183_uranic
uratic83016363_uratic

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 Limit134027967.29618369.9
3Display Results96960.0303200.0
 (SQL Overall)178691967.73223110.6
 
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.