History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plainsong"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
136 | 2024-05-03 08:41:48 | plainsong | 4 | 165329 | 220 | 25.876 | 6389.3 |
135 | 2024-04-20 07:21:45 | plainsong | 1 | 81242 | 2 | 1.640 | 49537.8 |
134 | 2024-04-07 20:05:26 | plainsong | 1 | 81242 | 2 | 2.546 | 31909.7 |
133 | 2024-04-01 04:31:41 | plainsong | 3 | 148641 | 17 | 8.936 | 16634.0 |
132 | 2024-03-31 10:44:54 | plainsong | 3 | 148641 | 17 | 17.796 | 8352.5 |
131 | 2024-03-31 10:44:56 | plainsong | 2 | 121436 | 3 | 12.703 | 9559.6 |
130 | 2024-03-31 09:41:46 | plainsong | 1 | 81242 | 2 | 1.563 | 51978.2 |
129 | 2024-03-23 08:50:17 | plainsong | 4 | 165329 | 220 | 32.796 | 5041.1 |
128 | 2024-03-19 17:50:11 | plainsong | 4 | 165329 | 220 | 43.566 | 3794.9 |
127 | 2024-03-18 23:33:23 | plainsong | 4 | 165329 | 220 | 41.390 | 3994.4 |
126 | 2024-03-18 01:35:09 | plainsong | 4 | 165329 | 220 | 32.970 | 5014.5 |
125 | 2024-03-18 01:34:58 | plainsong | 2 | 121436 | 3 | 11.596 | 10472.2 |
124 | 2024-03-18 01:34:58 | plainsong | 3 | 148641 | 17 | 11.060 | 13439.5 |
123 | 2024-03-18 01:33:37 | plainsong | 1 | 81242 | 2 | 4.173 | 19468.5 |
122 | 2024-03-05 02:49:49 | plainsong | 1 | 81242 | 2 | 4.983 | 16303.8 |
121 | 2024-02-06 17:03:33 | plainsong | 1 | 81242 | 2 | 4.813 | 16879.7 |
120 | 2024-02-05 13:47:22 | plainsong | 1 | 81242 | 2 | 3.033 | 26786.0 |
119 | 2024-01-31 09:16:18 | plainsong | 1 | 81242 | 2 | 1.330 | 61084.2 |
118 | 2024-01-28 12:27:39 | plainsong | 1 | 81242 | 2 | 1.233 | 65889.7 |
117 | 2024-01-22 05:09:59 | plainsong | 1 | 81242 | 2 | 1.233 | 65889.7 |
116 | 2023-12-27 19:57:07 | plainsong | 4 | 165329 | 220 | 11.843 | 13960.1 |
115 | 2023-12-27 19:57:06 | plainsong | 3 | 148641 | 17 | 7.160 | 20759.9 |
114 | 2023-12-27 19:57:09 | plainsong | 2 | 121436 | 3 | 3.796 | 31990.5 |
113 | 2023-12-16 18:31:47 | plainsong | 1 | 81242 | 2 | 1.466 | 55417.5 |
112 | 2023-11-14 00:50:38 | plainsong | 1 | 81242 | 2 | 1.346 | 60358.1 |
111 | 2023-11-02 15:09:52 | plainsong | 1 | 81242 | 2 | 1.876 | 43306.0 |
110 | 2023-10-06 20:34:15 | plainsong | 1 | 81242 | 2 | 1.406 | 57782.4 |
109 | 2023-09-06 12:07:00 | plainsong | 1 | 81242 | 2 | 1.406 | 57782.4 |
108 | 2023-04-10 19:18:50 | plainsong | 1 | 81242 | 2 | 1.200 | 67701.7 |
107 | 2022-12-20 19:09:21 | plainsong | 1 | 81242 | 2 | 1.360 | 59736.8 |
106 | 2022-11-24 01:55:27 | plainsong | 1 | 81242 | 2 | 1.233 | 65889.7 |
105 | 2022-11-18 13:08:33 | plainsong | 1 | 81242 | 2 | 1.300 | 62493.8 |
104 | 2022-06-12 04:08:09 | plainsong | 1 | 81242 | 2 | 2.500 | 32496.8 |
103 | 2022-01-04 22:00:20 | plainsong | 1 | 81242 | 2 | 1.343 | 60492.9 |
102 | 2021-08-27 10:25:33 | plainsong | 1 | 81242 | 2 | 1.266 | 64172.2 |
101 | 2021-04-29 10:01:25 | plainsong | 1 | 81242 | 2 | 2.876 | 28248.3 |
100 | 2021-01-17 10:39:44 | plainsong | 1 | 81242 | 2 | 1.360 | 59736.8 |
99 | 2020-11-10 02:01:40 | plainsong | 1 | 81242 | 2 | 1.310 | 62016.8 |
98 | 2020-10-03 10:40:06 | plainsong | 1 | 81242 | 2 | 1.220 | 66591.8 |
97 | 2020-06-01 10:51:38 | plainsong | 1 | 81242 | 2 | 1.343 | 60492.9 |
96 | 2020-03-27 02:00:16 | plainsong | 1 | 81242 | 2 | 1.420 | 57212.7 |
95 | 2020-03-12 22:56:10 | plainsong | 1 | 81242 | 2 | 1.233 | 65889.7 |
94 | 2020-02-25 16:16:54 | plainsong | 4 | 165329 | 220 | 15.593 | 10602.8 |
93 | 2020-02-18 01:24:41 | plainsong | 1 | 81242 | 2 | 2.906 | 27956.6 |
92 | 2020-02-09 14:10:52 | plainsong | 1 | 81242 | 2 | 1.390 | 58447.5 |
91 | 2020-02-08 19:20:20 | plainsong | 1 | 81242 | 2 | 1.593 | 50999.4 |
90 | 2020-02-07 17:26:24 | plainsong | 4 | 165329 | 220 | 24.783 | 6671.1 |
89 | 2020-02-06 12:08:16 | plainsong | 1 | 81242 | 2 | 1.406 | 57782.4 |
88 | 2020-02-06 11:32:59 | plainsong | 1 | 81242 | 2 | 3.156 | 25742.1 |
87 | 2020-02-05 12:51:10 | plainsong | 4 | 165329 | 220 | 27.453 | 6022.3 |
86 | 2020-02-02 13:57:04 | plainsong | 1 | 81242 | 2 | 1.393 | 58321.6 |
85 | 2020-02-02 01:16:41 | plainsong | 4 | 165329 | 220 | 17.876 | 9248.7 |
84 | 2020-02-01 06:35:04 | plainsong | 1 | 81242 | 2 | 1.483 | 54782.2 |
83 | 2020-01-30 09:17:16 | plainsong | 4 | 165329 | 220 | 13.830 | 11954.4 |
82 | 2020-01-27 15:15:09 | plainsong | 4 | 165329 | 220 | 13.373 | 12362.9 |
81 | 2020-01-26 20:39:51 | plainsong | 4 | 165329 | 220 | 15.406 | 10731.5 |
80 | 2020-01-25 18:24:00 | plainsong | 4 | 165329 | 220 | 31.736 | 5209.5 |
79 | 2020-01-13 23:03:32 | plainsong | 4 | 165329 | 220 | 19.830 | 8337.3 |
78 | 2020-01-10 16:41:27 | plainsong | 4 | 165329 | 220 | 11.750 | 14070.6 |
77 | 2020-01-08 22:11:29 | plainsong | 4 | 165329 | 220 | 15.203 | 10874.8 |
76 | 2020-01-07 22:59:24 | plainsong | 1 | 81242 | 2 | 1.483 | 54782.2 |
75 | 2020-01-07 14:43:24 | plainsong | 4 | 165329 | 220 | 15.266 | 10829.9 |
74 | 2020-01-07 00:04:44 | plainsong | 4 | 165329 | 220 | 19.470 | 8491.5 |
73 | 2020-01-06 16:16:34 | plainsong | 4 | 165329 | 220 | 25.846 | 6396.7 |
72 | 2020-01-06 16:14:37 | plainsong | 2 | 121436 | 3 | 3.610 | 33638.8 |
71 | 2020-01-06 09:17:44 | plainsong | 1 | 81242 | 2 | 1.706 | 47621.3 |
70 | 2019-12-26 05:50:41 | plainsong | 1 | 81242 | 2 | 1.406 | 57782.4 |
69 | 2019-10-26 06:37:45 | plainsong | 1 | 81242 | 2 | 1.283 | 63321.9 |
68 | 2019-10-23 00:37:19 | plainsong | 1 | 81242 | 2 | 2.530 | 32111.5 |
67 | 2019-06-22 15:14:30 | plainsong | 1 | 81242 | 2 | 1.436 | 56575.2 |
66 | 2019-04-01 07:36:14 | plainsong | 1 | 81242 | 2 | 1.323 | 61407.4 |
65 | 2019-02-16 12:34:29 | plainsong | 1 | 81242 | 2 | 1.276 | 63669.3 |
64 | 2018-10-04 05:21:08 | plainsong | 1 | 81242 | 2 | 1.416 | 57374.3 |
63 | 2018-09-14 07:48:28 | plainsong | 1 | 81242 | 2 | 1.340 | 60628.4 |
62 | 2018-09-07 17:02:44 | plainsong | 1 | 81242 | 2 | 1.376 | 59042.2 |
61 | 2018-06-20 21:24:26 | plainsong | 1 | 81242 | 2 | 1.460 | 55645.2 |
60 | 2018-06-19 05:50:11 | plainsong | 1 | 81242 | 2 | 1.536 | 52891.9 |
59 | 2018-05-12 16:20:09 | plainsong | 1 | 81242 | 2 | 1.353 | 60045.8 |
58 | 2018-01-25 18:47:27 | plainsong | 1 | 81242 | 2 | 2.173 | 37387.0 |
57 | 2017-11-14 14:45:39 | plainsong | 1 | 81242 | 2 | 1.946 | 41748.2 |
56 | 2017-11-07 04:06:58 | plainsong | 1 | 81242 | 2 | 2.013 | 40358.7 |
55 | 2017-08-23 22:47:04 | plainsong | 1 | 81242 | 2 | 1.610 | 50460.9 |
54 | 2017-05-14 04:34:07 | plainsong | 1 | 81242 | 2 | 1.636 | 49658.9 |
53 | 2017-04-09 14:16:48 | plainsong | 1 | 81242 | 2 | 1.666 | 48764.7 |
52 | 2017-04-04 19:28:54 | plainsong | 1 | 81242 | 2 | 1.690 | 48072.2 |
51 | 2017-03-22 03:12:24 | plainsong | 1 | 81242 | 2 | 1.690 | 48072.2 |
50 | 2016-12-08 21:19:34 | plainsong | 1 | 81242 | 2 | 1.630 | 49841.7 |
49 | 2016-11-21 14:49:42 | plainsong | 1 | 81242 | 2 | 1.756 | 46265.4 |
48 | 2016-09-05 22:27:34 | plainsong | 2 | 121436 | 3 | 5.616 | 21623.2 |
47 | 2016-09-04 11:23:39 | plainsong | 3 | 148641 | 17 | 12.316 | 12068.9 |
46 | 2016-08-31 00:07:21 | plainsong | 4 | 165329 | 220 | 15.690 | 10537.2 |
45 | 2016-08-23 17:24:55 | plainsong | 1 | 81242 | 2 | 1.546 | 52549.8 |
44 | 2016-08-20 14:39:41 | plainsong | 1 | 81242 | 2 | 1.980 | 41031.3 |
43 | 2016-04-02 01:39:31 | plainsong | 1 | 81242 | 2 | 1.450 | 56029.0 |
42 | 2016-02-29 09:56:20 | plainsong | 1 | 81242 | 2 | 2.880 | 28209.0 |
41 | 2016-02-10 20:11:18 | plainsong | 1 | 81242 | 2 | 1.420 | 57212.7 |
40 | 2016-02-10 12:11:14 | plainsong | 1 | 81242 | 2 | 1.440 | 56418.1 |
39 | 2015-11-03 02:56:20 | plainsong | 3 | 148641 | 17 | 13.260 | 11209.7 |
38 | 2015-11-03 02:30:00 | plainsong | 2 | 121436 | 3 | 3.550 | 34207.3 |
37 | 2015-11-03 02:02:44 | plainsong | 4 | 165329 | 220 | 21.680 | 7625.9 |