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 “macadam” 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.

71 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
macadam144685(None) 
macadams1545091macadams
macadamia1653232macadamia
madam10316222m__adam
papadam1486912papadam
academe1244703_academe
academy1543093_academy
acaudal1045783_acaudal
anadem939183_anadem
bacalao1146613bacalao
bemadam1445773bemadam
cicada1136413cicada_
cicadae1244853cicadae
cicadas1235993cicadas
decadal1137243decadal
facade1238803facad_e
facades1339033facades
faraday1445633faraday
hamada1239923hamada_
hamadas1339673hamadas
jacamar1844323jacamar
jacana1537933jacana_
jacanas1638263jacanas
jackdaw2442843jackdaw
lackaday1843133lackaday
lactam10310943lac_tam
macaber1336163macaber
macabre1335223macabre
macaco1247853maca_co
macacos1338083macacos
macadamias1752833macadamias
macadamize2652093macadamize
macaque2044053macaque
macaw12311763mac__aw
macaws1337023maca_ws
maccabaw1942003maccabaw
maced108528693maced__
macrame1338713mac_rame
macula103013673macula_
maculae113412863maculae
macular113011943macular
maculas113114023maculas
madame1139853m__adame
madams11310943m__adams
mahatma1443783mahatma
malady1237863malad_y
manana84816073manana_
mananas93414733mananas
mantram114011603mantram
maraca10314153maraca_
maracas11313773maracas
marram10313883ma_rram
masala8311813masala_
masalas9312053masalas
mascara1138023mascara_
mascaras1237693mascaras
matador1066253matador
mayday1535883ma_yday
milldam1245473milldam
monadal1047893monadal
pachadom1844183pachadom
panada94113053panada_
panadas103312213panadas
papadams15104783papadams
papadom1466763papadom
papadum1475233papadum
pappadam1443233pappadam
ramada9310183ramada_
ramadas1039303ramadas
salaam8711013sala_am
tarmacadam1751613tarmacadam

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.423422437.4
2DLD Change Limit134027716.93619323.4
3Display Results71710.0302366.7
 (SQL Overall)178691717.38924183.4
 
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.