History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nonplastic"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
148 | 2024-04-27 10:46:12 | nonplastic | 1 | 67641 | 3 | 2.733 | 24749.7 |
147 | 2024-04-24 16:56:00 | nonplastic | 4 | 161450 | 126 | 53.813 | 3000.2 |
146 | 2024-04-24 10:51:15 | nonplastic | 3 | 140603 | 21 | 22.873 | 6147.1 |
145 | 2024-04-24 10:50:58 | nonplastic | 4 | 161450 | 126 | 29.266 | 5516.6 |
144 | 2024-04-24 10:51:04 | nonplastic | 2 | 108824 | 4 | 7.513 | 14484.8 |
143 | 2024-04-24 10:49:53 | nonplastic | 1 | 67641 | 3 | 3.453 | 19589.1 |
142 | 2024-04-24 05:41:01 | nonplastic | 1 | 67641 | 3 | 1.280 | 52844.5 |
141 | 2024-04-06 06:42:11 | nonplastic | 1 | 67641 | 3 | 1.656 | 40846.0 |
140 | 2024-03-27 07:03:58 | nonplastic | 1 | 67641 | 3 | 1.376 | 49157.7 |
139 | 2024-03-27 04:01:57 | nonplastic | 1 | 67641 | 3 | 1.220 | 55443.4 |
138 | 2024-03-21 20:44:28 | nonplastic | 3 | 140603 | 21 | 23.063 | 6096.5 |
137 | 2024-03-21 20:44:27 | nonplastic | 2 | 108824 | 4 | 6.483 | 16786.1 |
136 | 2024-03-21 19:50:30 | nonplastic | 1 | 67641 | 3 | 1.093 | 61885.6 |
135 | 2024-03-20 01:30:09 | nonplastic | 1 | 67641 | 3 | 1.233 | 54858.9 |
134 | 2024-03-18 12:41:43 | nonplastic | 4 | 161450 | 126 | 19.906 | 8110.6 |
133 | 2024-03-14 17:36:17 | nonplastic | 4 | 161450 | 126 | 35.766 | 4514.1 |
132 | 2024-03-14 05:33:46 | nonplastic | 3 | 140603 | 21 | 16.563 | 8489.0 |
131 | 2024-03-14 05:33:42 | nonplastic | 2 | 108824 | 4 | 10.796 | 10080.0 |
130 | 2024-03-14 05:28:58 | nonplastic | 1 | 67641 | 3 | 1.156 | 58513.0 |
129 | 2024-03-11 20:18:42 | nonplastic | 4 | 161450 | 126 | 32.656 | 4944.0 |
128 | 2024-03-11 08:00:27 | nonplastic | 4 | 161450 | 126 | 25.956 | 6220.1 |
127 | 2024-03-10 19:42:29 | nonplastic | 4 | 161450 | 126 | 34.706 | 4651.9 |
126 | 2024-03-10 19:42:27 | nonplastic | 3 | 140603 | 21 | 20.830 | 6750.0 |
125 | 2024-03-10 19:42:22 | nonplastic | 2 | 108824 | 4 | 7.266 | 14977.2 |
124 | 2024-03-10 19:39:52 | nonplastic | 1 | 67641 | 3 | 1.266 | 53428.9 |
123 | 2024-02-25 08:59:22 | nonplastic | 1 | 67641 | 3 | 1.170 | 57812.8 |
122 | 2024-02-16 04:10:13 | nonplastic | 4 | 161450 | 126 | 26.186 | 6165.5 |
121 | 2024-02-16 04:10:13 | nonplastic | 3 | 140603 | 21 | 22.780 | 6172.2 |
120 | 2024-02-16 04:10:12 | nonplastic | 2 | 108824 | 4 | 3.876 | 28076.4 |
119 | 2024-02-16 02:00:03 | nonplastic | 1 | 67641 | 3 | 1.140 | 59334.2 |
118 | 2024-01-30 15:12:51 | nonplastic | 1 | 67641 | 3 | 1.716 | 39417.8 |
117 | 2024-01-30 06:37:39 | nonplastic | 1 | 67641 | 3 | 1.173 | 57665.0 |
116 | 2024-01-26 01:37:35 | nonplastic | 1 | 67641 | 3 | 1.110 | 60937.8 |
115 | 2023-12-31 23:07:39 | nonplastic | 1 | 67641 | 3 | 1.096 | 61716.2 |
114 | 2023-12-24 15:28:22 | nonplastic | 1 | 67641 | 3 | 1.123 | 60232.4 |
113 | 2023-11-03 23:17:04 | nonplastic | 1 | 67641 | 3 | 1.090 | 62056.0 |
112 | 2023-10-12 05:27:49 | nonplastic | 1 | 67641 | 3 | 1.233 | 54858.9 |
111 | 2023-08-09 07:45:43 | nonplastic | 1 | 67641 | 3 | 1.013 | 66773.0 |
110 | 2023-08-07 23:04:39 | nonplastic | 1 | 67641 | 3 | 1.013 | 66773.0 |
109 | 2023-05-06 02:12:55 | nonplastic | 1 | 67641 | 3 | 1.000 | 67641.0 |
108 | 2023-04-02 07:11:53 | nonplastic | 1 | 67641 | 3 | 0.983 | 68810.8 |
107 | 2023-03-01 17:27:50 | nonplastic | 1 | 67641 | 3 | 0.983 | 68810.8 |
106 | 2022-12-26 00:15:37 | nonplastic | 1 | 67641 | 3 | 1.000 | 67641.0 |
105 | 2022-11-17 12:00:25 | nonplastic | 1 | 67641 | 3 | 1.186 | 57032.9 |
104 | 2022-11-13 21:20:40 | nonplastic | 1 | 67641 | 3 | 1.170 | 57812.8 |
103 | 2022-09-12 09:39:40 | nonplastic | 1 | 67641 | 3 | 1.030 | 65670.9 |
102 | 2022-07-15 16:42:04 | nonplastic | 1 | 67641 | 3 | 0.983 | 68810.8 |
101 | 2022-06-18 12:03:56 | nonplastic | 1 | 67641 | 3 | 1.080 | 62630.6 |
100 | 2022-01-30 18:02:11 | nonplastic | 1 | 67641 | 3 | 1.140 | 59334.2 |
99 | 2021-09-27 22:05:52 | nonplastic | 1 | 67641 | 3 | 1.063 | 63632.2 |
98 | 2021-06-18 11:49:48 | nonplastic | 1 | 67641 | 3 | 1.156 | 58513.0 |
97 | 2021-03-12 03:18:02 | nonplastic | 1 | 67641 | 3 | 1.140 | 59334.2 |
96 | 2021-03-04 21:33:56 | nonplastic | 1 | 67641 | 3 | 1.106 | 61158.2 |
95 | 2020-11-26 06:16:37 | nonplastic | 1 | 67641 | 3 | 1.000 | 67641.0 |
94 | 2020-10-24 21:40:57 | nonplastic | 1 | 67641 | 3 | 1.046 | 64666.3 |
93 | 2020-10-21 02:29:01 | nonplastic | 1 | 67641 | 3 | 1.156 | 58513.0 |
92 | 2020-10-10 17:47:29 | nonplastic | 1 | 67641 | 3 | 1.033 | 65480.2 |
91 | 2020-08-20 14:54:34 | nonplastic | 1 | 67641 | 3 | 1.203 | 56226.9 |
90 | 2020-04-27 11:54:19 | nonplastic | 1 | 67641 | 3 | 1.126 | 60071.9 |
89 | 2020-03-22 19:58:54 | nonplastic | 1 | 67641 | 3 | 2.156 | 31373.4 |
88 | 2020-02-29 11:55:58 | nonplastic | 1 | 67641 | 3 | 2.500 | 27056.4 |
87 | 2020-02-29 10:36:05 | nonplastic | 1 | 67641 | 3 | 2.483 | 27241.6 |
86 | 2020-02-22 16:15:24 | nonplastic | 1 | 67641 | 3 | 1.233 | 54858.9 |
85 | 2020-02-10 00:21:40 | nonplastic | 1 | 67641 | 3 | 1.376 | 49157.7 |
84 | 2020-02-05 05:16:21 | nonplastic | 1 | 67641 | 3 | 2.156 | 31373.4 |
83 | 2020-02-03 15:02:15 | nonplastic | 1 | 67641 | 3 | 2.826 | 23935.2 |
82 | 2020-01-22 18:35:06 | nonplastic | 1 | 67641 | 3 | 2.513 | 26916.4 |
81 | 2020-01-18 14:47:52 | nonplastic | 1 | 67641 | 3 | 1.250 | 54112.8 |
80 | 2020-01-15 21:42:04 | nonplastic | 1 | 67641 | 3 | 1.266 | 53428.9 |
79 | 2020-01-06 00:58:16 | nonplastic | 1 | 67641 | 3 | 1.156 | 58513.0 |
78 | 2020-01-03 05:20:36 | nonplastic | 1 | 67641 | 3 | 1.623 | 41676.5 |
77 | 2019-10-04 08:24:54 | nonplastic | 1 | 67641 | 3 | 0.993 | 68117.8 |
76 | 2019-09-09 19:11:05 | nonplastic | 1 | 67641 | 3 | 0.950 | 71201.1 |
75 | 2019-06-24 23:03:33 | nonplastic | 1 | 67641 | 3 | 1.120 | 60393.8 |
74 | 2019-02-28 01:53:04 | nonplastic | 1 | 67641 | 3 | 1.220 | 55443.4 |
73 | 2018-11-02 02:47:23 | nonplastic | 1 | 67641 | 3 | 1.066 | 63453.1 |
72 | 2018-07-23 00:24:51 | nonplastic | 1 | 67641 | 3 | 1.266 | 53428.9 |
71 | 2018-07-11 18:56:39 | nonplastic | 1 | 67641 | 3 | 1.016 | 66575.8 |
70 | 2018-01-15 10:27:52 | nonplastic | 1 | 67641 | 3 | 1.460 | 46329.5 |
69 | 2018-01-02 02:10:30 | nonplastic | 1 | 67641 | 3 | 1.453 | 46552.6 |
68 | 2017-12-09 19:16:05 | nonplastic | 1 | 67641 | 3 | 1.996 | 33888.3 |
67 | 2017-12-09 19:10:45 | nonplastic | 1 | 67641 | 3 | 2.196 | 30801.9 |
66 | 2017-07-17 16:18:41 | nonplastic | 1 | 67641 | 3 | 1.366 | 49517.6 |
65 | 2016-10-20 00:19:04 | nonplastic | 1 | 67641 | 3 | 1.673 | 40431.0 |
64 | 2016-09-14 14:27:06 | nonplastic | 1 | 67641 | 3 | 1.373 | 49265.1 |
63 | 2016-09-11 11:59:43 | nonplastic | 3 | 140603 | 21 | 9.826 | 14309.3 |
62 | 2016-09-05 20:29:09 | nonplastic | 1 | 67641 | 3 | 1.790 | 37788.3 |
61 | 2016-07-31 22:30:06 | nonplastic | 2 | 108824 | 4 | 8.266 | 13165.3 |
60 | 2016-07-19 12:10:58 | nonplastic | 1 | 67641 | 3 | 1.796 | 37662.0 |
59 | 2016-07-11 22:51:20 | nonplastic | 1 | 67641 | 3 | 1.773 | 38150.6 |
58 | 2016-06-22 17:39:47 | nonplastic | 4 | 161450 | 126 | 50.153 | 3219.1 |
57 | 2016-06-15 10:37:43 | nonplastic | 4 | 161450 | 126 | 19.950 | 8092.7 |
56 | 2016-06-11 15:07:25 | nonplastic | 4 | 161450 | 126 | 18.303 | 8821.0 |
55 | 2016-06-09 09:35:47 | nonplastic | 4 | 161450 | 126 | 21.313 | 7575.2 |
54 | 2016-05-31 15:27:45 | nonplastic | 4 | 161450 | 126 | 13.313 | 12127.2 |
53 | 2016-05-21 01:49:21 | nonplastic | 4 | 161450 | 126 | 26.093 | 6187.5 |
52 | 2016-04-16 21:53:01 | nonplastic | 3 | 140603 | 21 | 7.096 | 19814.4 |
51 | 2016-04-16 21:34:57 | nonplastic | 4 | 161450 | 126 | 17.563 | 9192.6 |
50 | 2016-04-16 21:24:20 | nonplastic | 2 | 108824 | 4 | 3.276 | 33218.6 |
49 | 2016-03-31 17:03:08 | nonplastic | 1 | 67641 | 3 | 1.293 | 52313.2 |