Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “machzor” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
machzor234426(None) 
machzors2444111machzors
mahzor2035111ma_hzor
macho126120152mach_o_
machos135217492mach_os
machzorim2751702machzorim
mahzors2135122ma_hzors
abhor10411063_abh_or
achier113914263_achier
achoo10315083_ach_oo
actor71116083_ac_tor
alachlor1343303alachlor
anchor113911973anch_or
bachelor1564073bachelor
cachou13310623cach_ou
factor11911463fac_tor
ichor1039483_ich_or
macaber1336163macaber
macaco1247853macaco_
macacos1338083macacos
macer912126943mac__er
mach116134483mach___
mache125925303mach__e
maches134827233mach_es
machete14310883machete
machine14313493machine
machree1438513machree
machs125722563mach__s
macon94519953mac__on
macro94718173mac_ro_
macron103615673mac_ron
macros104017013mac_ros
macular113011943macular
mahoe10315573ma_h_oe
mahzorim2442543ma_hzorim
major145212923ma__jor
malodor1044563malodor
mamzer19459833ma_mzer
manhood1338993manhood
manor78023933ma__nor
marcher143912973march_er
markhoor1742973markhoor
markhor1635463markhor
masher114123203mash_er
matador1066253matador
matchbox2442623matchbox
matcher143214283match_er
matzo16312893ma_tzo_
matzoh2035483ma_tzoh
matzos1749263ma_tzos
matzot17710983ma_tzot
mayor106616623ma__yor
mazer165722423ma__zer
mucho125013443much_o_
mucor94011943muc__or
nacho105414383nach_o_
nachos115014183nach_os
razor143012603ra__zor
tachyon1544623tachyon
yachter1534913yachter

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.420425454.8
2DLD Change Limit134027606.94019312.2
3Display Results60600.0134615.4
 (SQL Overall)178691607.37324235.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.