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

84 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
malefactions195314(None) 
malefaction1853401malefaction_
maledictions1752952maledictions
malefactors1852692malefact_ors
rarefactions1752412rarefactions
benefactions1952693benefactions
macerations1548473macera_tions
malediction1653113malediction_
malefactor1752623malefact_o_r
malfunctions1952663malfunctions
olfactions1563873_ol_factions
rarefaction1652653rarefaction_
tumefactions1951623tumefactions
valedictions1852223valedictions
abreactions1544194_abreactions
aerations9317904_a_era_tions
affections1845894_a_ffections
alations82518894_al__a_tions
alienations1147884_aliena_tions
allegations1246044allega_tions
allocations1347774_allocations
alterations11511664_altera_tions
altercations1446374_altercations
attractions1376404_attractions
benefaction1852824benefaction_
bilections14136504bile__ctions
bolections14137294bole__ctions
calefactory2152044calefact_ory
caseations1258304case_a_tions
catenations1348364catena_tions
defections161510204__defections
delegations1348034delega_tions
elections112414974_ele__ctions
elevations1338634_eleva_tions
exactions1838924___exactions
factions133013064____factions
flections14239214_fle__ctions
halations12312394hal__a_tions
interactions14410464interactions
lacerations1348334lacera_tions
lallations1038744lal_la_tions
lections102413844__le__ctions
legations102711924__lega_tions
liquefactions276854liquefactions
maceration1449614macera_tion_
maculations1569624macula_tions
malathions1543874mal__athions
maledicting1752724maledicti_ng
malfunction1852804malfunction_
malpositions1653674malpositions
malpractices2061604malpractices
malversations1852564malversations
marinations13411274marina_tions
mastications1649414mastications
maturations1348444matura_tions
metafictions1952654metafictions
moderations1448274modera_tions
molestations1475474molestations
olfaction1464234_ol_faction_
overactions1648214_overactions
palliations1347724pallia_tions
palmations1438734pal_ma_tions
palpations1437654pal_pa_tions
putrefactions2052274putrefactions
rarefactional18101764rarefactional
reactions11711714__re_actions
redactions1359134__redactions
refections151811644__refections
refractions16127724__refractions
relegations1248974relega_tions
salivations1448734saliva_tions
saltations10310624sal_ta_tions
salutations1147644saluta_tions
salvations1338134sal_va_tions
satisfactions18141914satisfactions
selections12310874sele__ctions
stupefactions2051494stupefactions
sulfations13107814sul_fa_tions
tolerations1158134tolera_tions
tumefaction1851784tumefaction_
valediction1752404valediction_
validations1547244valida_tions
vallations1339094val_la_tions
valuations1348784val_ua_tions

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 Filter1786911247900.393454684.5
2DLD Change Limit124790846.64018793.7
3Display Results84840.0461826.1
 (SQL Overall)178691847.07925242.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.