History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asphalting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
131 | 2024-03-20 01:58:21 | asphalting | 1 | 67641 | 1 | 1.013 | 66773.0 |
130 | 2024-03-10 07:36:54 | asphalting | 4 | 161450 | 291 | 29.080 | 5551.9 |
129 | 2024-03-10 07:35:26 | asphalting | 3 | 140603 | 22 | 21.986 | 6395.1 |
128 | 2024-03-08 08:59:58 | asphalting | 4 | 161450 | 291 | 36.110 | 4471.1 |
127 | 2024-03-08 09:00:03 | asphalting | 3 | 140603 | 22 | 22.156 | 6346.0 |
126 | 2024-03-05 08:37:38 | asphalting | 1 | 67641 | 1 | 1.220 | 55443.4 |
125 | 2024-03-03 19:09:35 | asphalting | 3 | 140603 | 22 | 16.206 | 8676.0 |
124 | 2024-03-03 19:09:21 | asphalting | 2 | 108824 | 3 | 10.830 | 10048.4 |
123 | 2024-03-03 18:10:19 | asphalting | 1 | 67641 | 1 | 1.203 | 56226.9 |
122 | 2024-03-03 01:07:48 | asphalting | 4 | 161450 | 291 | 26.250 | 6150.5 |
121 | 2024-02-22 23:23:49 | asphalting | 4 | 161450 | 291 | 10.093 | 15996.2 |
120 | 2024-02-19 21:58:21 | asphalting | 2 | 108824 | 3 | 3.326 | 32719.2 |
119 | 2024-02-19 17:45:28 | asphalting | 1 | 67641 | 1 | 1.153 | 58665.2 |
118 | 2024-02-13 04:56:38 | asphalting | 3 | 140603 | 22 | 12.656 | 11109.6 |
117 | 2024-02-06 21:53:38 | asphalting | 1 | 67641 | 1 | 2.173 | 31127.9 |
116 | 2024-02-06 09:52:46 | asphalting | 1 | 67641 | 1 | 1.200 | 56367.5 |
115 | 2024-02-02 20:15:32 | asphalting | 1 | 67641 | 1 | 1.143 | 59178.5 |
114 | 2024-01-30 13:00:19 | asphalting | 1 | 67641 | 1 | 1.126 | 60071.9 |
113 | 2024-01-30 07:55:29 | asphalting | 1 | 67641 | 1 | 1.140 | 59334.2 |
112 | 2024-01-30 06:48:51 | asphalting | 1 | 67641 | 1 | 1.173 | 57665.0 |
111 | 2024-01-21 16:35:56 | asphalting | 1 | 67641 | 1 | 1.030 | 65670.9 |
110 | 2024-01-18 22:13:37 | asphalting | 3 | 140603 | 22 | 5.500 | 25564.2 |
109 | 2024-01-18 15:33:11 | asphalting | 4 | 161450 | 291 | 16.203 | 9964.2 |
108 | 2024-01-17 21:13:22 | asphalting | 4 | 161450 | 291 | 21.030 | 7677.1 |
107 | 2023-12-19 03:23:59 | asphalting | 1 | 67641 | 1 | 1.250 | 54112.8 |
106 | 2023-12-18 18:59:23 | asphalting | 3 | 140603 | 22 | 7.093 | 19822.8 |
105 | 2023-11-26 20:58:06 | asphalting | 1 | 67641 | 1 | 1.173 | 57665.0 |
104 | 2023-11-17 21:26:33 | asphalting | 4 | 161450 | 291 | 10.440 | 15464.6 |
103 | 2023-11-04 10:21:25 | asphalting | 1 | 67641 | 1 | 1.190 | 56841.2 |
102 | 2023-10-29 07:57:28 | asphalting | 3 | 140603 | 22 | 5.890 | 23871.5 |
101 | 2023-10-11 04:34:33 | asphalting | 1 | 67641 | 1 | 1.063 | 63632.2 |
100 | 2023-09-12 10:04:42 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
99 | 2023-08-18 22:27:23 | asphalting | 4 | 161450 | 291 | 9.330 | 17304.4 |
98 | 2023-08-06 22:30:02 | asphalting | 3 | 140603 | 22 | 5.546 | 25352.1 |
97 | 2023-06-26 12:13:43 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
96 | 2023-05-04 12:19:26 | asphalting | 4 | 161450 | 291 | 10.296 | 15680.8 |
95 | 2023-04-18 18:47:15 | asphalting | 3 | 140603 | 22 | 6.013 | 23383.2 |
94 | 2023-04-05 08:33:09 | asphalting | 1 | 67641 | 1 | 1.080 | 62630.6 |
93 | 2023-02-10 20:11:46 | asphalting | 4 | 161450 | 291 | 9.326 | 17311.8 |
92 | 2023-01-25 10:44:06 | asphalting | 3 | 140603 | 22 | 5.906 | 23806.8 |
91 | 2023-01-22 07:37:47 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
90 | 2022-11-21 19:30:52 | asphalting | 4 | 161450 | 291 | 9.296 | 17367.7 |
89 | 2022-11-19 00:55:02 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
88 | 2022-11-07 23:44:11 | asphalting | 3 | 140603 | 22 | 5.186 | 27112.0 |
87 | 2022-07-11 00:53:07 | asphalting | 1 | 67641 | 1 | 1.016 | 66575.8 |
86 | 2022-06-10 07:52:09 | asphalting | 3 | 140603 | 22 | 5.283 | 26614.2 |
85 | 2022-05-18 21:11:48 | asphalting | 1 | 67641 | 1 | 1.173 | 57665.0 |
84 | 2022-05-07 05:37:07 | asphalting | 4 | 161450 | 291 | 10.250 | 15751.2 |
83 | 2022-04-29 09:57:56 | asphalting | 1 | 67641 | 1 | 1.326 | 51011.3 |
82 | 2021-07-21 05:38:30 | asphalting | 1 | 67641 | 1 | 1.013 | 66773.0 |
81 | 2021-03-22 14:51:48 | asphalting | 1 | 67641 | 1 | 1.123 | 60232.4 |
80 | 2021-01-04 11:53:37 | asphalting | 1 | 67641 | 1 | 1.046 | 64666.3 |
79 | 2020-11-12 16:55:23 | asphalting | 1 | 67641 | 1 | 1.110 | 60937.8 |
78 | 2020-03-27 20:28:56 | asphalting | 1 | 67641 | 1 | 1.110 | 60937.8 |
77 | 2020-03-24 18:21:13 | asphalting | 1 | 67641 | 1 | 1.033 | 65480.2 |
76 | 2020-03-01 14:23:22 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
75 | 2020-02-19 02:21:17 | asphalting | 1 | 67641 | 1 | 1.283 | 52721.0 |
74 | 2020-02-11 01:14:11 | asphalting | 1 | 67641 | 1 | 2.563 | 26391.3 |
73 | 2020-02-03 22:13:33 | asphalting | 1 | 67641 | 1 | 1.173 | 57665.0 |
72 | 2020-02-03 15:27:21 | asphalting | 1 | 67641 | 1 | 1.220 | 55443.4 |
71 | 2020-02-01 13:45:06 | asphalting | 1 | 67641 | 1 | 1.216 | 55625.8 |
70 | 2020-01-29 22:22:24 | asphalting | 1 | 67641 | 1 | 1.000 | 67641.0 |
69 | 2020-01-18 15:50:29 | asphalting | 2 | 108824 | 3 | 6.296 | 17284.6 |
68 | 2020-01-18 15:49:54 | asphalting | 3 | 140603 | 22 | 6.576 | 21381.2 |
67 | 2020-01-18 11:14:23 | asphalting | 1 | 67641 | 1 | 2.673 | 25305.3 |
66 | 2020-01-07 15:07:49 | asphalting | 1 | 67641 | 1 | 1.203 | 56226.9 |
65 | 2020-01-04 20:17:39 | asphalting | 1 | 67641 | 1 | 1.080 | 62630.6 |
64 | 2019-11-28 14:32:16 | asphalting | 1 | 67641 | 1 | 1.050 | 64420.0 |
63 | 2019-08-26 23:22:56 | asphalting | 1 | 67641 | 1 | 1.136 | 59543.1 |
62 | 2019-05-17 22:18:34 | asphalting | 1 | 67641 | 1 | 1.130 | 59859.3 |
61 | 2019-01-26 21:12:03 | asphalting | 1 | 67641 | 1 | 2.170 | 31171.0 |
60 | 2019-01-23 16:21:08 | asphalting | 1 | 67641 | 1 | 1.203 | 56226.9 |
59 | 2018-09-26 19:31:12 | asphalting | 1 | 67641 | 1 | 1.293 | 52313.2 |
58 | 2018-07-28 21:27:55 | asphalting | 1 | 67641 | 1 | 1.003 | 67438.7 |
57 | 2018-06-27 01:18:59 | asphalting | 1 | 67641 | 1 | 1.166 | 58011.1 |
56 | 2018-05-11 00:28:43 | asphalting | 1 | 67641 | 1 | 1.080 | 62630.6 |
55 | 2018-03-25 08:23:18 | asphalting | 1 | 67641 | 1 | 1.340 | 50478.4 |
54 | 2018-01-03 16:56:39 | asphalting | 1 | 67641 | 1 | 1.556 | 43471.1 |
53 | 2017-11-10 19:51:25 | asphalting | 1 | 67641 | 1 | 1.423 | 47534.1 |
52 | 2017-06-26 11:26:20 | asphalting | 1 | 67641 | 1 | 1.430 | 47301.4 |
51 | 2017-06-15 03:13:53 | asphalting | 1 | 67641 | 1 | 1.390 | 48662.6 |
50 | 2016-11-30 03:30:02 | asphalting | 1 | 67641 | 1 | 1.413 | 47870.5 |
49 | 2016-11-16 01:16:13 | asphalting | 1 | 67641 | 1 | 1.683 | 40190.7 |
48 | 2016-10-18 04:21:54 | asphalting | 1 | 67641 | 1 | 1.560 | 43359.6 |
47 | 2016-10-10 15:07:38 | asphalting | 1 | 67641 | 1 | 1.416 | 47769.1 |
46 | 2016-08-21 17:06:27 | asphalting | 1 | 67641 | 1 | 1.703 | 39718.7 |
45 | 2016-07-12 19:46:46 | asphalting | 1 | 67641 | 1 | 1.800 | 37578.3 |
44 | 2016-06-25 04:35:37 | asphalting | 2 | 108824 | 3 | 6.486 | 16778.3 |
43 | 2016-06-21 10:01:21 | asphalting | 3 | 140603 | 22 | 17.936 | 7839.2 |
42 | 2016-06-18 23:33:14 | asphalting | 1 | 67641 | 1 | 1.550 | 43639.4 |
41 | 2016-06-16 15:51:59 | asphalting | 1 | 67641 | 1 | 1.706 | 39648.9 |
40 | 2016-06-11 08:10:37 | asphalting | 1 | 67641 | 1 | 3.553 | 19037.7 |
39 | 2016-06-02 08:28:08 | asphalting | 1 | 67641 | 1 | 1.176 | 57517.9 |
38 | 2016-04-12 12:15:00 | asphalting | 4 | 161450 | 291 | 28.366 | 5691.7 |
37 | 2016-04-01 10:05:26 | asphalting | 4 | 161450 | 291 | 13.856 | 11652.0 |
36 | 2016-03-31 10:54:24 | asphalting | 1 | 67641 | 1 | 1.550 | 43639.4 |
35 | 2016-03-06 20:32:42 | asphalting | 1 | 67641 | 1 | 1.173 | 57665.0 |
34 | 2016-02-26 06:35:54 | asphalting | 1 | 67641 | 1 | 5.480 | 12343.2 |
33 | 2016-02-22 21:57:01 | asphalting | 4 | 161450 | 291 | 27.110 | 5955.4 |
32 | 2016-02-21 06:06:57 | asphalting | 1 | 67641 | 1 | 1.726 | 39189.5 |