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

92 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
agential95815(None) 
agentival1353661agentival
agenting1039382agenting
agentive1248042agentive
amentia9310152amentia_
amentias1039412amentias
argental947932argent_al
aventail1145342aventail
cadential1246392cadential
genial74917612_gen_ial
genital849792_genital
gentian8310102_gentian
gentil74115122_genti_l
tangential1154442tangential
abbatial1284673abbatial
abettal946073abe_ttal
accentual1343673accentual
acetal84314903ace_t_al
achenial1348283achen_ial
adenoidal1143663adenoidal
aecial84817313a_e_cial
aerial64625713a_e_rial
aestival1145483a_estival
agencies1138743agencies
agenda837253agen_da_
agendas936933agen_das
agenesia945983agenesia_
agenesias1045363agenesias
agenetic1138203ageneti_c
agenize172910153agen_ize
agent65829643agent___
agented939423agent_ed
agentings1134443agentings
agentives1346443agentives
agentries1048233agentries
agentry11165753agent_ry
agents74816293agent__s
agnail739533ag_nai_l
agnatical1246163agnatical
agonal7410053agon__al
agrestal945653agrest_al
antiar6317173a__ntiar
antral65719413a__ntral
argentic1149023argenti_c
argentine1047893argentine
argentite1047813argentite
aventails1244993aventails
benthal1247953_benthal
bestial9311643_bestial
biennial1065093biennial
cental84420963_cent_al
central93114473_central
demential1248693demential
denial74720513_den_ial
dental74319173_dent_al
dentil74017883_denti_l
dentinal939503_dentinal
entail61114343__entail
entia5318203__entia_
essential946083essential
eventual1144883eventual
fetial95716193_fe_tial
general81010933_general
genetical1247583_genetical
genitals937243_genitals
genitival1343293_genitival
genteel836753_genteel
gentians937563_gentians
gentile83515293_gentile
gestical1138993_gestical
identical1246313identical
inertial8411723inertial
lentil64315393_lenti_l
magenta1038623magent_a_
magentas1137923magent_as
menial84223033_men_ial
mental84521603_ment_al
omental93210413oment_al
parental10310943parent_al
penial84120893_pen_ial
potential1148533potential
regental948943regent_al
rental63922023_rent_al
retial64724993_re_tial
sciential1146323sciential
tangental1044783tangent_al
tertial7313863_tertial
ungenial946973ungen_ial
venial94218283_ven_ial
ventail10310453_ventail
ventral103612173_ventral
xenial133414903_xen_ial

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162927.98318309.2
3Display Results92920.0332787.9
 (SQL Overall)178691928.42221217.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.