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 “macules” with Change Limit: [1] [2] [3]

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

52 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
macules11401513(None) 
mackles154415751mackles
macles107023221mac_les
maculas113114021maculas
macule104115271macule_
maculed123510051maculed
aculei839792_aculei
aculeus937512_aculeus
acutes83917722_acutes
ampules1189432ampules
bascules1236682bascules
cackles153717202cackles
caules85927252ca_ules
hackles162917062hackles
jacales16310322jacales
lacunes9159622lacunes
locules92812602locules
maces97139962mac__es
maches134827232mac_hes
mackle143716432mackle_
mackled164111922mackled
macle96127002mac_le_
macled116718112mac_led
macula103013672macul_a
maculae113412862maculae
macular113011942macular
maculates132013722maculates
mailes84329112ma_iles
males75049792ma__les
mangles104021462mangles
mantles94820702mantles
manures9313352manures
maples104819422ma_ples
marbles114516652marbles
matures9314302matures
mauled94817822ma_uled
mauler84416712ma_uler
maulers94213302ma_ulers
mauls76524952ma_ul_s
mauves113811552ma_uves
mickles153415002mickles
modules102511002modules
muckles153413252muckles
mucuses11148512mucuses
mules75034292m__ules
mutules9311842mutules
myceles1435212myceles
oscules938122oscules
papules112411572papules
saccules1237032saccules
tackles133816522tackles
vacuoles1345012vacuoles

Search took 4 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 Filter1786911076710.500357382.0
2DLD Change Limit107671523.23333303.7
3Display Results52520.0163250.0
 (SQL Overall)178691523.74947663.6
 
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.