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

67 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
famishments215338(None) 
famishment2054541famishment_
banishments1864292banishments
ravishments1954102ravishments
abashments1744533_abashments
amassments1444493_amassments
ambushments2063693_ambushments
amusements1446233_amusements
banishment1775973banishment_
enmeshments1854363enmeshments
famishes1658283famish_e__s
fleshments1843853f_leshments
garnishments1873333garnishments
punishments1853443punishments
ravishment1855123ravishment_
abasements1446534_abasements
abashment1646024_abashment_
abolishments1993544abolishments
admonishments2162544admonishments
advisements1754824advisements
affixments2543074affi_xments
ailments1039434_a_i_lments
alightments1792764_alightments
alignments1344634_alignments
aliments10311094_ali__ments
alinements1247134_alinements
amassment1346414_amassment_
amazements2345314_amazements
ambushment1964444_ambushment_
amendments1554374_amendments
amusement1347754_amusement_
bailments1346464ba_i_lments
basements1348264ba__sements
bemusements1754444bemusements
blandishments21102334blandishments
casements1348584ca__sements
catchments1944454ca_tchments
demolishments21122994demolishments
diminishments2162964diminishments
easements11410334ea__sements
encashments1875064encashments
enlistments1345664enlistments
enmeshment1755394enmeshment_
enrichments1855334enrichments
famished1766024famish_e__d
famishing1845234famish_in_g
figments1446944f__i_gments
filaments1446654f__ilaments
fishmeals1742034f__ishmeals
fishnets1445634f__ishne_ts
fitments1376794f__i_tments
fleshment1745504f_leshment_
garnishment1774374garnishment_
habiliments1852554habiliments
harassments1653434harassments
hatchments2043884ha_tchments
languishments1962274languishments
misagents1246794__misagents
misevents1456004__misevents
mismeets12297734__mis_meets
nourishments1753694nourishments
parchments1944984pa_rchments
punishment1754544punishment_
raiments1039904ra_i__ments
remitments1446844remi_tments
samisens1035484samis__en_s
stablishments20132494stablishments

Search took 9 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 Limit148819678.12618313.9
3Display Results67670.0461456.5
 (SQL Overall)178691678.59220797.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.