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

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

85 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
malefaction185340(None) 
malefactions1953141malefactions
malediction1653112malediction
malefactor1752622malefact_or
rarefaction1652652rarefaction
benefaction1852823benefaction
maceration1449613macera_tion
maledictions1752953maledictions
malefactors1852693malefactors
malfunction1852803malfunction
olfaction1464233_ol_faction
rarefactions1752413rarefactions
tumefaction1851783tumefaction
valediction1752403valediction
abreaction1444654_abreaction
aeration8319934_a_era_tion
affection1745894_a_ffection
alation72920554_al__a_tion
alienation1048794_aliena_tion
allegation1146814allega_tion
allocation1248574_allocation
alteration10612904_altera_tion
altercation1347014_altercation
attraction1276954_attraction
benefactions1952694benefactions
bilection13156804bile__ction
bolection13117674bole__ction
calefactory2152044calefactory
caseation1199514case_a_tion
catenation1249524catena_tion
defection151610644__defection
delegation1238884delega_tion
election102015354_ele__ction
elevation1239234_eleva_tion
exaction1738954___exaction
faction122613334____faction
flection13239564_fle__ction
halation11313854hal__a_tion
interaction13411814interaction
laceration1249574lacera_tion
lallation939494lal_la_tion
lection92614864__le__ction
legation92412934__lega_tion
liquefaction265994liquefaction
macerations1548474macera_tions
maculation14510984macula_tion
malathion1444514mal__athion
maledicting1752724maledicting
malfunctions1952664malfunctions
malolactic1653704malolacti_c
malposition1553964malposition
malpractice1952154malpractice
malversation1752724malversation
marination12312814marina_tion
mastication15610294mastication
maturation1249514matura_tion
metafiction1852844metafiction
moderation1348654modera_tion
molestation1365964molestation
olfactions1563874_ol_factions
overaction1547994_overaction
palliation1248504pallia_tion
palmation13310224pal_ma_tion
palpation1339074pal_pa_tion
putrefaction1952464putrefaction
rarefactional18101764rarefactional
reaction10612604__re_action
redaction1259664__redaction
refection141512284__refection
refraction15137904__refraction
relegation11610024relega_tion
salivation1349814saliva_tion
saltation9312004sal_ta_tion
salutation1048904saluta_tion
salvation1239294sal_va_tion
satisfaction17142114satisfaction
selection11311274sele__ction
stupefaction1951614stupefaction
sulfation1288784sul_fa_tion
toleration1048964tolera_tion
tumefactions1951624tumefactions
valedictions1852224valedictions
validation1448414valida_tion
vallation1239754val_la_tion
valuation1249974val_ua_tion

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819858.72017066.4
3Display Results85850.0461847.8
 (SQL Overall)178691859.18619452.5
 
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.