History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1100 | 2024-04-20 05:55:44 | gates | 1 | 28756 | 28 | 1.170 | 24577.8 |
1099 | 2024-04-19 05:50:15 | gates | 1 | 28756 | 28 | 0.513 | 56054.6 |
1098 | 2024-04-19 00:04:32 | gates | 1 | 28756 | 28 | 1.093 | 26309.2 |
1097 | 2024-04-03 03:57:51 | gates | 1 | 28756 | 28 | 1.593 | 18051.5 |
1096 | 2024-03-31 04:30:49 | gates | 1 | 28756 | 28 | 1.296 | 22188.3 |
1095 | 2024-03-28 09:34:45 | gates | 1 | 28756 | 28 | 0.563 | 51076.4 |
1094 | 2024-03-27 03:43:49 | gates | 1 | 28756 | 28 | 1.156 | 24875.4 |
1093 | 2024-03-21 23:01:10 | gates | 1 | 28756 | 28 | 0.733 | 39230.6 |
1092 | 2024-03-21 01:29:31 | gates | 1 | 28756 | 28 | 1.093 | 26309.2 |
1091 | 2024-03-19 22:41:17 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1090 | 2024-03-16 13:33:29 | gates | 1 | 28756 | 28 | 0.563 | 51076.4 |
1089 | 2024-03-15 19:43:38 | gates | 1 | 28756 | 28 | 0.533 | 53951.2 |
1088 | 2024-03-14 19:00:44 | gates | 1 | 28756 | 28 | 1.186 | 24246.2 |
1087 | 2024-03-14 14:25:37 | gates | 1 | 28756 | 28 | 1.110 | 25906.3 |
1086 | 2024-03-13 19:03:02 | gates | 1 | 28756 | 28 | 1.156 | 24875.4 |
1085 | 2024-03-12 23:44:47 | gates | 1 | 28756 | 28 | 0.593 | 48492.4 |
1084 | 2024-03-03 23:11:00 | gates | 2 | 53800 | 455 | 3.360 | 16011.9 |
1083 | 2024-03-03 22:28:12 | gates | 1 | 28756 | 28 | 0.546 | 52666.7 |
1082 | 2024-03-01 10:42:54 | gates | 1 | 28756 | 28 | 0.626 | 45936.1 |
1081 | 2024-02-25 18:12:34 | gates | 1 | 28756 | 28 | 1.123 | 25606.4 |
1080 | 2024-02-23 12:30:59 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1079 | 2024-01-22 21:03:00 | gates | 1 | 28756 | 28 | 1.173 | 24514.9 |
1078 | 2024-01-18 15:31:54 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1077 | 2024-01-02 12:39:51 | gates | 2 | 53800 | 455 | 1.703 | 31591.3 |
1076 | 2023-12-26 09:01:43 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1075 | 2023-12-13 18:19:47 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1074 | 2023-12-08 18:11:54 | gates | 2 | 53800 | 455 | 1.466 | 36698.5 |
1073 | 2023-11-27 16:13:42 | gates | 2 | 53800 | 455 | 1.733 | 31044.4 |
1072 | 2023-11-22 08:04:02 | gates | 2 | 53800 | 455 | 1.550 | 34709.7 |
1071 | 2023-11-15 08:06:41 | gates | 1 | 28756 | 28 | 0.450 | 63902.2 |
1070 | 2023-11-12 05:20:53 | gates | 2 | 53800 | 455 | 1.533 | 35094.6 |
1069 | 2023-11-11 01:50:31 | gates | 1 | 28756 | 28 | 0.876 | 32826.5 |
1068 | 2023-11-09 02:33:44 | gates | 1 | 28756 | 28 | 0.423 | 67981.1 |
1067 | 2023-11-06 15:45:17 | gates | 1 | 28756 | 28 | 0.483 | 59536.2 |
1066 | 2023-10-26 17:13:49 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1065 | 2023-10-21 23:45:54 | gates | 1 | 28756 | 28 | 0.440 | 65354.5 |
1064 | 2023-10-18 10:08:13 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1063 | 2023-10-14 01:22:55 | gates | 1 | 28756 | 28 | 0.486 | 59168.7 |
1062 | 2023-10-07 03:47:05 | gates | 2 | 53800 | 455 | 1.716 | 31352.0 |
1061 | 2023-10-05 03:19:42 | gates | 1 | 28756 | 28 | 0.486 | 59168.7 |
1060 | 2023-09-28 02:47:40 | gates | 2 | 53800 | 455 | 3.280 | 16402.4 |
1059 | 2023-09-24 14:09:45 | gates | 1 | 28756 | 28 | 0.483 | 59536.2 |
1058 | 2023-09-19 19:30:58 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1057 | 2023-09-16 18:27:27 | gates | 1 | 28756 | 28 | 0.470 | 61183.0 |
1056 | 2023-09-03 01:44:58 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1055 | 2023-07-19 03:42:49 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1054 | 2023-07-17 15:34:48 | gates | 2 | 53800 | 455 | 1.580 | 34050.6 |
1053 | 2023-06-12 18:00:19 | gates | 1 | 28756 | 28 | 0.546 | 52666.7 |
1052 | 2023-06-08 11:24:32 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1051 | 2023-04-01 01:34:02 | gates | 2 | 53800 | 455 | 1.563 | 34421.0 |
1050 | 2023-03-31 13:04:01 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1049 | 2023-03-30 05:22:04 | gates | 1 | 28756 | 28 | 0.486 | 59168.7 |
1048 | 2023-03-10 07:53:27 | gates | 1 | 28756 | 28 | 0.483 | 59536.2 |
1047 | 2023-01-14 11:37:39 | gates | 1 | 28756 | 28 | 0.486 | 59168.7 |
1046 | 2022-12-30 00:33:57 | gates | 2 | 53800 | 455 | 1.453 | 37026.8 |
1045 | 2022-12-08 16:14:53 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1044 | 2022-11-02 19:14:12 | gates | 1 | 28756 | 28 | 0.470 | 61183.0 |
1043 | 2022-10-30 11:58:29 | gates | 1 | 28756 | 28 | 0.420 | 68466.7 |
1042 | 2022-10-29 10:18:18 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1041 | 2022-10-28 10:55:29 | gates | 1 | 28756 | 28 | 0.483 | 59536.2 |
1040 | 2022-10-27 09:58:03 | gates | 1 | 28756 | 28 | 0.466 | 61708.2 |
1039 | 2022-10-26 21:15:11 | gates | 1 | 28756 | 28 | 0.420 | 68466.7 |
1038 | 2022-10-25 08:24:14 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1037 | 2022-10-24 13:00:16 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1036 | 2022-10-23 12:14:54 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1035 | 2022-10-22 10:01:22 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1034 | 2022-10-21 16:13:17 | gates | 1 | 28756 | 28 | 0.530 | 54256.6 |
1033 | 2022-10-20 15:04:43 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1032 | 2022-10-19 12:40:26 | gates | 1 | 28756 | 28 | 0.656 | 43835.4 |
1031 | 2022-10-18 20:30:31 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1030 | 2022-10-16 17:23:52 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1029 | 2022-10-15 18:48:20 | gates | 1 | 28756 | 28 | 0.450 | 63902.2 |
1028 | 2022-10-14 18:59:35 | gates | 1 | 28756 | 28 | 0.450 | 63902.2 |
1027 | 2022-10-13 11:33:20 | gates | 1 | 28756 | 28 | 0.470 | 61183.0 |
1026 | 2022-10-12 16:02:21 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1025 | 2022-10-11 12:51:59 | gates | 1 | 28756 | 28 | 0.423 | 67981.1 |
1024 | 2022-10-10 21:18:40 | gates | 1 | 28756 | 28 | 0.483 | 59536.2 |
1023 | 2022-10-09 15:57:18 | gates | 1 | 28756 | 28 | 0.546 | 52666.7 |
1022 | 2022-10-08 13:12:04 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1021 | 2022-10-07 14:45:47 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1020 | 2022-09-12 05:35:25 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1019 | 2022-08-31 23:41:26 | gates | 1 | 28756 | 28 | 0.450 | 63902.2 |
1018 | 2022-08-31 02:49:45 | gates | 2 | 53800 | 455 | 1.373 | 39184.3 |
1017 | 2022-08-28 17:15:56 | gates | 2 | 53800 | 455 | 1.390 | 38705.0 |
1016 | 2022-08-08 00:36:11 | gates | 2 | 53800 | 455 | 1.780 | 30224.7 |
1015 | 2022-08-06 22:07:00 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1014 | 2022-07-03 08:44:22 | gates | 1 | 28756 | 28 | 0.440 | 65354.5 |
1013 | 2022-06-25 20:21:27 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1012 | 2022-06-22 14:58:25 | gates | 1 | 28756 | 28 | 0.440 | 65354.5 |
1011 | 2022-06-20 10:28:51 | gates | 1 | 28756 | 28 | 0.440 | 65354.5 |
1010 | 2022-06-16 08:42:58 | gates | 1 | 28756 | 28 | 0.516 | 55728.7 |
1009 | 2022-06-15 18:16:58 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1008 | 2022-06-08 22:29:42 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1007 | 2022-06-08 19:07:40 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1006 | 2022-06-07 10:13:00 | gates | 1 | 28756 | 28 | 0.440 | 65354.5 |
1005 | 2022-06-01 21:07:01 | gates | 1 | 28756 | 28 | 0.470 | 61183.0 |
1004 | 2022-05-26 09:31:03 | gates | 1 | 28756 | 28 | 0.513 | 56054.6 |
1003 | 2022-03-23 15:06:39 | gates | 2 | 53800 | 455 | 2.250 | 23911.1 |
1002 | 2022-03-17 02:24:49 | gates | 1 | 28756 | 28 | 0.626 | 45936.1 |
1001 | 2022-02-18 09:22:31 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |