History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"insert"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1053 | 2025-01-06 10:19:11 | insert | 3 | 112716 | 530 | 13.266 | 8496.6 |
| 1052 | 2025-01-06 04:05:42 | insert | 3 | 112716 | 530 | 33.580 | 3356.6 |
| 1051 | 2025-01-06 04:05:47 | insert | 2 | 82551 | 55 | 12.923 | 6387.9 |
| 1050 | 2025-01-06 04:05:29 | insert | 1 | 48755 | 6 | 1.970 | 24748.7 |
| 1049 | 2024-12-30 19:57:01 | insert | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 1048 | 2024-12-28 11:01:03 | insert | 2 | 82551 | 55 | 2.470 | 33421.5 |
| 1047 | 2024-12-28 11:00:59 | insert | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 1046 | 2024-12-09 13:53:37 | insert | 2 | 82551 | 55 | 2.546 | 32423.8 |
| 1045 | 2024-12-09 13:53:32 | insert | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 1044 | 2024-12-08 22:00:01 | insert | 3 | 112716 | 530 | 21.360 | 5277.0 |
| 1043 | 2024-12-08 00:23:25 | insert | 3 | 112716 | 530 | 19.880 | 5669.8 |
| 1042 | 2024-12-07 09:39:02 | insert | 2 | 82551 | 55 | 8.250 | 10006.2 |
| 1041 | 2024-12-07 01:16:18 | insert | 3 | 112716 | 530 | 27.926 | 4036.2 |
| 1040 | 2024-12-07 00:16:25 | insert | 3 | 112716 | 530 | 24.063 | 4684.2 |
| 1039 | 2024-12-07 00:16:26 | insert | 2 | 82551 | 55 | 7.126 | 11584.5 |
| 1038 | 2024-12-07 00:16:20 | insert | 1 | 48755 | 6 | 5.700 | 8553.5 |
| 1037 | 2024-11-28 03:57:33 | insert | 1 | 48755 | 6 | 5.813 | 8387.2 |
| 1036 | 2024-11-09 09:18:52 | insert | 1 | 48755 | 6 | 2.750 | 17729.1 |
| 1035 | 2024-11-06 14:33:43 | insert | 1 | 48755 | 6 | 4.096 | 11903.1 |
| 1034 | 2024-10-28 23:12:34 | insert | 1 | 48755 | 6 | 4.830 | 10094.2 |
| 1033 | 2024-10-10 06:35:16 | insert | 1 | 48755 | 6 | 4.343 | 11226.1 |
| 1032 | 2024-10-09 19:34:45 | insert | 2 | 82551 | 55 | 12.500 | 6604.1 |
| 1031 | 2024-10-08 22:39:27 | insert | 1 | 48755 | 6 | 2.126 | 22932.7 |
| 1030 | 2024-10-08 13:46:53 | insert | 2 | 82551 | 55 | 2.186 | 37763.5 |
| 1029 | 2024-10-08 13:46:09 | insert | 3 | 112716 | 530 | 5.423 | 20784.8 |
| 1028 | 2024-10-07 04:33:50 | insert | 3 | 112716 | 530 | 45.346 | 2485.7 |
| 1027 | 2024-10-07 03:07:30 | insert | 3 | 112716 | 530 | 23.016 | 4897.3 |
| 1026 | 2024-10-07 02:36:14 | insert | 3 | 112716 | 530 | 46.013 | 2449.7 |
| 1025 | 2024-10-07 02:36:13 | insert | 2 | 82551 | 55 | 19.793 | 4170.7 |
| 1024 | 2024-10-07 02:36:10 | insert | 1 | 48755 | 6 | 6.173 | 7898.1 |
| 1023 | 2024-09-28 23:43:29 | insert | 1 | 48755 | 6 | 5.093 | 9572.9 |
| 1022 | 2024-09-07 16:24:33 | insert | 1 | 48755 | 6 | 1.626 | 29984.6 |
| 1021 | 2024-09-05 08:15:13 | insert | 1 | 48755 | 6 | 4.313 | 11304.2 |
| 1020 | 2024-08-31 09:41:33 | insert | 1 | 48755 | 6 | 2.983 | 16344.3 |
| 1019 | 2024-08-30 01:59:05 | insert | 1 | 48755 | 6 | 6.733 | 7241.2 |
| 1018 | 2024-08-29 13:01:12 | insert | 1 | 48755 | 6 | 2.983 | 16344.3 |
| 1017 | 2024-08-28 12:21:29 | insert | 1 | 48755 | 6 | 5.343 | 9125.0 |
| 1016 | 2024-08-16 14:49:56 | insert | 1 | 48755 | 6 | 3.110 | 15676.8 |
| 1015 | 2024-08-09 16:53:35 | insert | 1 | 48755 | 6 | 0.983 | 49598.2 |
| 1014 | 2024-08-08 14:55:53 | insert | 3 | 112716 | 530 | 26.860 | 4196.4 |
| 1013 | 2024-08-08 14:00:09 | insert | 1 | 48755 | 6 | 2.156 | 22613.6 |
| 1012 | 2024-08-01 22:15:27 | insert | 2 | 82551 | 55 | 11.720 | 7043.6 |
| 1011 | 2024-08-01 11:07:50 | insert | 3 | 112716 | 530 | 17.540 | 6426.2 |
| 1010 | 2024-08-01 09:09:10 | insert | 3 | 112716 | 530 | 25.080 | 4494.3 |
| 1009 | 2024-08-01 00:33:06 | insert | 2 | 82551 | 55 | 10.216 | 8080.6 |
| 1008 | 2024-08-01 00:10:31 | insert | 3 | 112716 | 530 | 27.766 | 4059.5 |
| 1007 | 2024-07-31 16:34:31 | insert | 3 | 112716 | 530 | 17.076 | 6600.8 |
| 1006 | 2024-07-31 14:35:28 | insert | 3 | 112716 | 530 | 16.906 | 6667.2 |
| 1005 | 2024-07-31 14:35:27 | insert | 2 | 82551 | 55 | 5.656 | 14595.3 |
| 1004 | 2024-07-31 14:35:25 | insert | 1 | 48755 | 6 | 3.860 | 12630.8 |
| 1003 | 2024-07-31 02:53:50 | insert | 1 | 48755 | 6 | 1.030 | 47335.0 |
| 1002 | 2024-07-30 05:39:07 | insert | 1 | 48755 | 6 | 1.470 | 33166.7 |
| 1001 | 2024-07-29 17:01:58 | insert | 1 | 48755 | 6 | 1.813 | 26891.9 |
| 1000 | 2024-07-16 11:18:02 | insert | 1 | 48755 | 6 | 2.966 | 16438.0 |
| 999 | 2024-07-12 18:40:02 | insert | 1 | 48755 | 6 | 4.500 | 10834.4 |
| 998 | 2024-07-05 11:14:10 | insert | 1 | 48755 | 6 | 2.830 | 17227.9 |
| 997 | 2024-06-30 19:47:31 | insert | 1 | 48755 | 6 | 3.093 | 15763.0 |
| 996 | 2024-06-29 22:58:13 | insert | 1 | 48755 | 6 | 3.046 | 16006.2 |
| 995 | 2024-06-29 14:28:37 | insert | 1 | 48755 | 6 | 0.923 | 52822.3 |
| 994 | 2024-06-28 20:51:08 | insert | 1 | 48755 | 6 | 4.453 | 10948.8 |
| 993 | 2024-06-24 12:41:08 | insert | 3 | 112716 | 530 | 33.266 | 3388.3 |
| 992 | 2024-06-23 12:22:45 | insert | 1 | 48755 | 6 | 3.890 | 12533.4 |
| 991 | 2024-06-22 09:43:45 | insert | 3 | 112716 | 530 | 10.716 | 10518.5 |
| 990 | 2024-06-22 08:25:56 | insert | 3 | 112716 | 530 | 11.940 | 9440.2 |
| 989 | 2024-06-21 14:02:48 | insert | 3 | 112716 | 530 | 27.080 | 4162.3 |
| 988 | 2024-06-21 10:33:41 | insert | 3 | 112716 | 530 | 23.173 | 4864.1 |
| 987 | 2024-06-20 18:49:11 | insert | 3 | 112716 | 530 | 25.500 | 4420.2 |
| 986 | 2024-06-17 22:25:47 | insert | 3 | 112716 | 530 | 14.563 | 7739.9 |
| 985 | 2024-06-04 00:58:29 | insert | 1 | 48755 | 6 | 2.826 | 17252.3 |
| 984 | 2024-05-31 10:57:09 | insert | 1 | 48755 | 6 | 4.593 | 10615.1 |
| 983 | 2024-05-30 10:55:42 | insert | 1 | 48755 | 6 | 4.970 | 9809.9 |
| 982 | 2024-05-30 10:46:24 | insert | 1 | 48755 | 6 | 2.643 | 18446.8 |
| 981 | 2024-05-29 06:45:05 | insert | 1 | 48755 | 6 | 3.563 | 13683.7 |
| 980 | 2024-05-28 00:12:56 | insert | 1 | 48755 | 6 | 3.783 | 12887.9 |
| 979 | 2024-04-27 11:12:51 | insert | 1 | 48755 | 6 | 1.263 | 38602.5 |
| 978 | 2024-04-03 09:56:05 | insert | 1 | 48755 | 6 | 1.923 | 25353.6 |
| 977 | 2024-03-27 18:53:16 | insert | 1 | 48755 | 6 | 0.873 | 55847.7 |
| 976 | 2024-03-02 07:23:14 | insert | 2 | 82551 | 55 | 5.623 | 14681.0 |
| 975 | 2024-03-02 06:05:56 | insert | 3 | 112716 | 530 | 6.563 | 17174.5 |
| 974 | 2024-02-28 07:12:16 | insert | 3 | 112716 | 530 | 15.096 | 7466.6 |
| 973 | 2024-02-27 07:04:46 | insert | 2 | 82551 | 55 | 2.626 | 31436.0 |
| 972 | 2024-02-27 07:04:27 | insert | 3 | 112716 | 530 | 5.783 | 19490.9 |
| 971 | 2024-02-26 23:00:12 | insert | 3 | 112716 | 530 | 6.186 | 18221.1 |
| 970 | 2024-02-26 23:00:11 | insert | 2 | 82551 | 55 | 5.423 | 15222.4 |
| 969 | 2024-02-26 19:15:42 | insert | 1 | 48755 | 6 | 1.470 | 33166.7 |
| 968 | 2024-02-21 05:36:18 | insert | 1 | 48755 | 6 | 2.893 | 16852.7 |
| 967 | 2024-01-01 06:16:50 | insert | 3 | 112716 | 530 | 7.906 | 14257.0 |
| 966 | 2024-01-01 06:16:51 | insert | 2 | 82551 | 55 | 4.876 | 16930.1 |
| 965 | 2023-12-20 21:34:58 | insert | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 964 | 2023-12-07 19:50:49 | insert | 2 | 82551 | 55 | 2.640 | 31269.3 |
| 963 | 2023-12-07 19:50:45 | insert | 3 | 112716 | 530 | 5.673 | 19868.9 |
| 962 | 2023-11-27 04:02:36 | insert | 2 | 82551 | 55 | 2.450 | 33694.3 |
| 961 | 2023-11-27 04:02:23 | insert | 3 | 112716 | 530 | 4.690 | 24033.3 |
| 960 | 2023-11-23 11:47:14 | insert | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 959 | 2023-11-20 09:45:15 | insert | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 958 | 2023-11-13 19:47:02 | insert | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 957 | 2023-11-10 23:13:47 | insert | 1 | 48755 | 6 | 0.800 | 60943.8 |
| 956 | 2023-11-08 02:15:14 | insert | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 955 | 2023-11-08 01:58:38 | insert | 1 | 48755 | 6 | 0.780 | 62506.4 |
| 954 | 2023-10-23 08:33:27 | insert | 1 | 48755 | 6 | 0.856 | 56956.8 |