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 “catenated” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
catenated123891(None) 
catenate10312831catenate_
catenates11311811catenates
carinated123414272carinated
caseated11310712case_ated
casemated1446952casemated
catenae9311372catena_e_
caveated1439132cave_ated
crenated113013912c_renated
patented1188892paten_ted
patinated123911412patinated
accented13107773accen_ted
acerated113113983_acerated
acetated112010683_acetated
acierated1238283acierated
activated1567883activated
actuated1138743act_uated
aerated85322373_a_erated
agented939423_agen_ted
alienated1047743alienated
alternated1145723alternated
antedated1146703antedated
attenuated1183203attenuated
cadenced1435523caden_ced
caffeinated2052043caffeinated
calendared1442593calendared
canaled103615563ca__naled
canted94825783ca__n_ted
canulated12310673canulated
capitated14159043capitated
captivated1844763captivated
carbonated1547243carbonated
carinate103320253carinate_
caseate9314783case_ate_
caseates10313713case_ates
caseinate1148243caseinate_
caseinates1247443caseinates
casemate1239843casemate_
casemates1349523casemates
castellated1443273castellated
castigated1446323castigated
castrated1239513castrated
catena8312483catena___
catenaries1248663catenaries
catenary1346583catena_ry
catenas9313113catena__s
catenating1348683catenating
catenation1249523catenation
catenoid1149113caten_oid
catered103117773cate__red
cathected1744543cathected
catkinate1545823catkinate_
catnaper1294933cat_naper
catnapped1692503cat_napped
catted95422473cat___ted
caudated1238063ca_udated
cavitated15177353cavitated
cayenned1443163cayen_ned
cemented1338373cemen_ted
cerated103922473c__erated
cheated134416343c_he_ated
chelated142610493c_helated
citrated112712253cit_rated
cleated103417843c_le_ated
coenacted1445803c_oenacted
concatenated1753523concatenated
contented12313043conten_ted
corelated12411823corelated
coronated123313323coronated
covenanted1663803covenanted
created104323453c_re_ated
cremated133412963c_remated
crenate93317113c_renate_
cuneated11310103cune_ated
cybernated1842823cybernated
detonated1138213detonated
extenuated1843753extenuated
galeated104111583gale_ated
intonated1048303intonated
iterated91213823_iterated
lacerated122210683lacerated
lamented1138193lamen_ted
laminated122610283laminated
lanated8313203la__nated
latened8711923laten__ed
lateraled1047463lateraled
macerated142010523macerated
marinated122513173marinated
maturated1249163maturated
paginated13309463paginated
parented11912213paren_ted
patentee1099943paten_tee
patinaed11407833patina_ed
patinate103016313patinate_
patinates113814693patinates
patriated1238533patriated
saponated1245733saponated
satiated9311603sat_iated
saturated1038993saturated
stagnated1145143stagnated
talented938423talen_ted
teated74924023__te_ated
tenanted937043__tenanted
tented74221003__ten_ted
untenanted1144453untenanted
untented92613413unten_ted
vaginated14328153vaginated
venenated1345903venenated

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411088.28017951.8
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.74920424.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.