History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"swearword"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
133 | 2024-05-05 06:49:29 | swearword | 4 | 165329 | 129 | 15.296 | 10808.6 |
132 | 2024-05-05 06:24:02 | swearword | 3 | 148641 | 18 | 7.500 | 19818.8 |
131 | 2024-05-01 06:33:28 | swearword | 1 | 81242 | 2 | 2.983 | 27235.0 |
130 | 2024-04-25 11:35:59 | swearword | 4 | 165329 | 129 | 38.016 | 4348.9 |
129 | 2024-04-25 11:35:56 | swearword | 3 | 148641 | 18 | 28.456 | 5223.5 |
128 | 2024-04-25 11:35:55 | swearword | 2 | 121436 | 3 | 10.420 | 11654.1 |
127 | 2024-04-25 10:16:38 | swearword | 1 | 81242 | 2 | 3.483 | 23325.3 |
126 | 2024-04-24 20:24:50 | swearword | 4 | 165329 | 129 | 31.346 | 5274.3 |
125 | 2024-04-24 20:24:50 | swearword | 3 | 148641 | 18 | 18.610 | 7987.2 |
124 | 2024-04-24 20:24:45 | swearword | 2 | 121436 | 3 | 8.373 | 14503.3 |
123 | 2024-04-24 18:37:16 | swearword | 1 | 81242 | 2 | 2.156 | 37681.8 |
122 | 2024-04-13 01:30:00 | swearword | 1 | 81242 | 2 | 1.623 | 50056.7 |
121 | 2024-04-10 08:23:55 | swearword | 1 | 81242 | 2 | 2.390 | 33992.5 |
120 | 2024-03-31 21:09:43 | swearword | 1 | 81242 | 2 | 3.173 | 25604.2 |
119 | 2024-03-30 19:43:30 | swearword | 1 | 81242 | 2 | 6.156 | 13197.2 |
118 | 2024-03-18 10:34:08 | swearword | 4 | 165329 | 129 | 43.740 | 3779.8 |
117 | 2024-03-18 10:34:06 | swearword | 3 | 148641 | 18 | 12.330 | 12055.2 |
116 | 2024-03-18 10:34:07 | swearword | 2 | 121436 | 3 | 8.906 | 13635.3 |
115 | 2024-03-18 07:20:20 | swearword | 1 | 81242 | 2 | 1.326 | 61268.5 |
114 | 2024-03-11 23:24:39 | swearword | 1 | 81242 | 2 | 1.453 | 55913.3 |
113 | 2024-03-10 22:52:00 | swearword | 1 | 81242 | 2 | 1.360 | 59736.8 |
112 | 2024-03-05 11:19:22 | swearword | 1 | 81242 | 2 | 1.750 | 46424.0 |
111 | 2024-02-29 03:20:56 | swearword | 1 | 81242 | 2 | 1.466 | 55417.5 |
110 | 2024-02-14 19:54:27 | swearword | 1 | 81242 | 2 | 1.220 | 66591.8 |
109 | 2024-02-12 01:30:55 | swearword | 1 | 81242 | 2 | 3.906 | 20799.3 |
108 | 2024-02-07 01:01:18 | swearword | 1 | 81242 | 2 | 1.580 | 51419.0 |
107 | 2024-01-29 12:30:43 | swearword | 1 | 81242 | 2 | 1.423 | 57092.1 |
106 | 2023-12-21 01:03:07 | swearword | 1 | 81242 | 2 | 1.376 | 59042.2 |
105 | 2023-11-23 23:20:32 | swearword | 1 | 81242 | 2 | 1.233 | 65889.7 |
104 | 2023-10-24 16:24:48 | swearword | 1 | 81242 | 2 | 1.296 | 62686.7 |
103 | 2023-10-06 05:36:03 | swearword | 1 | 81242 | 2 | 1.266 | 64172.2 |
102 | 2023-08-02 12:49:35 | swearword | 1 | 81242 | 2 | 1.236 | 65729.8 |
101 | 2023-04-28 06:56:39 | swearword | 1 | 81242 | 2 | 1.326 | 61268.5 |
100 | 2023-02-21 17:04:12 | swearword | 1 | 81242 | 2 | 1.216 | 66810.9 |
99 | 2022-12-19 09:31:41 | swearword | 1 | 81242 | 2 | 1.390 | 58447.5 |
98 | 2022-08-30 01:32:58 | swearword | 1 | 81242 | 2 | 1.423 | 57092.1 |
97 | 2021-03-26 21:48:47 | swearword | 1 | 81242 | 2 | 1.500 | 54161.3 |
96 | 2021-03-01 00:14:51 | swearword | 1 | 81242 | 2 | 1.216 | 66810.9 |
95 | 2021-01-10 04:12:54 | swearword | 1 | 81242 | 2 | 1.390 | 58447.5 |
94 | 2020-10-22 10:12:48 | swearword | 1 | 81242 | 2 | 1.250 | 64993.6 |
93 | 2020-03-28 07:28:12 | swearword | 1 | 81242 | 2 | 2.923 | 27794.0 |
92 | 2020-03-24 20:42:59 | swearword | 4 | 165329 | 129 | 22.470 | 7357.8 |
91 | 2020-03-23 11:08:44 | swearword | 4 | 165329 | 129 | 18.156 | 9106.0 |
90 | 2020-03-04 14:52:18 | swearword | 4 | 165329 | 129 | 13.393 | 12344.4 |
89 | 2020-02-17 19:03:46 | swearword | 1 | 81242 | 2 | 4.750 | 17103.6 |
88 | 2020-02-14 09:16:28 | swearword | 4 | 165329 | 129 | 14.503 | 11399.6 |
87 | 2020-02-14 04:39:58 | swearword | 4 | 165329 | 129 | 14.656 | 11280.6 |
86 | 2020-02-13 22:47:51 | swearword | 4 | 165329 | 129 | 26.516 | 6235.1 |
85 | 2020-02-13 01:58:28 | swearword | 1 | 81242 | 2 | 1.530 | 53099.3 |
84 | 2020-02-12 20:26:52 | swearword | 4 | 165329 | 129 | 24.156 | 6844.2 |
83 | 2020-02-09 14:55:34 | swearword | 1 | 81242 | 2 | 2.970 | 27354.2 |
82 | 2020-02-05 02:39:20 | swearword | 1 | 81242 | 2 | 1.626 | 49964.3 |
81 | 2020-02-05 00:56:31 | swearword | 4 | 165329 | 129 | 11.813 | 13995.5 |
80 | 2020-02-05 00:55:53 | swearword | 3 | 148641 | 18 | 6.186 | 24028.6 |
79 | 2020-02-05 00:50:10 | swearword | 2 | 121436 | 3 | 3.780 | 32125.9 |
78 | 2020-02-04 20:24:06 | swearword | 1 | 81242 | 2 | 1.580 | 51419.0 |
77 | 2020-02-03 18:15:52 | swearword | 1 | 81242 | 2 | 3.766 | 21572.5 |
76 | 2020-01-25 13:43:53 | swearword | 1 | 81242 | 2 | 1.966 | 41323.5 |
75 | 2020-01-17 08:24:28 | swearword | 1 | 81242 | 2 | 1.546 | 52549.8 |
74 | 2020-01-06 16:11:22 | swearword | 1 | 81242 | 2 | 2.983 | 27235.0 |
73 | 2020-01-03 13:46:25 | swearword | 1 | 81242 | 2 | 1.283 | 63321.9 |
72 | 2019-11-03 11:25:49 | swearword | 1 | 81242 | 2 | 1.406 | 57782.4 |
71 | 2019-07-17 12:44:23 | swearword | 1 | 81242 | 2 | 1.336 | 60809.9 |
70 | 2019-07-16 03:35:05 | swearword | 1 | 81242 | 2 | 1.180 | 68849.2 |
69 | 2019-03-02 18:36:53 | swearword | 1 | 81242 | 2 | 1.373 | 59171.2 |
68 | 2018-10-14 20:25:48 | swearword | 1 | 81242 | 2 | 1.423 | 57092.1 |
67 | 2018-09-28 20:51:26 | swearword | 1 | 81242 | 2 | 1.223 | 66428.5 |
66 | 2018-06-27 07:52:24 | swearword | 1 | 81242 | 2 | 1.316 | 61734.0 |
65 | 2018-06-25 08:48:04 | swearword | 1 | 81242 | 2 | 1.366 | 59474.4 |
64 | 2018-06-24 07:41:53 | swearword | 1 | 81242 | 2 | 1.313 | 61875.1 |
63 | 2017-11-29 01:52:26 | swearword | 1 | 81242 | 2 | 2.066 | 39323.3 |
62 | 2017-03-10 21:12:35 | swearword | 1 | 81242 | 2 | 1.693 | 47987.0 |
61 | 2017-03-03 05:23:19 | swearword | 1 | 81242 | 2 | 1.696 | 47902.1 |
60 | 2017-03-01 10:27:31 | swearword | 1 | 81242 | 2 | 1.700 | 47789.4 |
59 | 2017-02-13 19:04:24 | swearword | 1 | 81242 | 2 | 2.026 | 40099.7 |
58 | 2017-02-09 23:42:43 | swearword | 1 | 81242 | 2 | 1.960 | 41450.0 |
57 | 2017-02-09 22:54:33 | swearword | 1 | 81242 | 2 | 1.863 | 43608.2 |
56 | 2017-01-28 03:19:28 | swearword | 1 | 81242 | 2 | 1.510 | 53802.6 |
55 | 2016-11-27 14:52:04 | swearword | 1 | 81242 | 2 | 3.443 | 23596.3 |
54 | 2016-11-26 17:28:21 | swearword | 1 | 81242 | 2 | 1.683 | 48272.1 |
53 | 2016-10-23 09:24:30 | swearword | 1 | 81242 | 2 | 1.896 | 42849.2 |
52 | 2016-09-06 00:51:15 | swearword | 1 | 81242 | 2 | 1.626 | 49964.3 |
51 | 2016-09-05 13:08:13 | swearword | 1 | 81242 | 2 | 1.606 | 50586.6 |
50 | 2016-08-21 00:07:24 | swearword | 1 | 81242 | 2 | 1.600 | 50776.3 |
49 | 2016-06-27 16:25:05 | swearword | 3 | 148641 | 18 | 12.370 | 12016.2 |
48 | 2016-06-27 08:25:48 | swearword | 2 | 121436 | 3 | 7.643 | 15888.5 |
47 | 2016-06-27 08:04:37 | swearword | 4 | 165329 | 129 | 21.420 | 7718.4 |
46 | 2016-06-11 11:20:50 | swearword | 2 | 121436 | 3 | 4.856 | 25007.4 |
45 | 2016-06-11 10:58:48 | swearword | 3 | 148641 | 18 | 13.003 | 11431.3 |
44 | 2016-06-10 19:16:24 | swearword | 4 | 165329 | 129 | 30.116 | 5489.7 |
43 | 2016-06-10 19:11:04 | swearword | 1 | 81242 | 2 | 2.166 | 37507.8 |
42 | 2016-05-10 15:43:51 | swearword | 3 | 148641 | 18 | 7.806 | 19041.9 |
41 | 2016-04-13 16:41:33 | swearword | 3 | 148641 | 18 | 12.893 | 11528.8 |
40 | 2016-03-17 04:45:42 | swearword | 1 | 81242 | 2 | 1.370 | 59300.7 |
39 | 2016-02-27 12:03:48 | swearword | 1 | 81242 | 2 | 1.516 | 53589.7 |
38 | 2016-02-22 22:17:25 | swearword | 3 | 148641 | 18 | 7.913 | 18784.4 |
37 | 2016-02-15 17:02:01 | swearword | 3 | 148641 | 18 | 7.343 | 20242.5 |
36 | 2016-02-11 01:04:43 | swearword | 3 | 148641 | 18 | 9.060 | 16406.3 |
35 | 2016-02-07 20:23:38 | swearword | 3 | 148641 | 18 | 7.340 | 20250.8 |
34 | 2016-02-03 08:42:43 | swearword | 1 | 81242 | 2 | 1.493 | 54415.3 |