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

61 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
imbalming164372(None) 
embalming1644261embalming
gimbaling15134442gimbal_ing
gimballing16202922gimballing
imbarking1843612imbarking
imblazing2344062imblazing
impaling1338252impal_ing
ambling121411793amb_l_ing
balding114015063__balding
baling94829693__bal_ing
balking143717353__balking
balling104424763__balling
bamming144611813__bamming
becalming1635283becalming
blaming123515693__blaming
caballing1436883caballing
calming123915973__calming
embanking1843813embanking
embarking1844193embarking
embarring1444513embarring
embaying1635263emba_ying
emblazing2344853emblazing
embleming1644433embleming
empaling1338363empal_ing
imaging1138083im_a_ging
imbalm1246323imbalm___
imbalmed1543293imbalm_ed
imbalmer1443193imbalm_er
imbalmers1543103imbalmers
imbalms1334553imbalm__s
imbedding1643243imbedding
imbibing1534043imb_ibing
imbodying1842713imbodying
imbosoming1752173imbosoming
imbruing1344003imb_ruing
imbruting1443773imbruting
imbuing1236103imb__uing
impacting1635943impacting
impairing1445473impairing
imparking1834713imparking
imparting1437243imparting
impasting1436323impasting
impawning1743423impawning
impelling1436913impelling
implying1635533im_plying
impulsing1444643impulsing
inarming1138343i_narming
infalling1356243infalling
inflaming1546263inflaming
inhaling1239523inhal_ing
inwalling1385633inwalling
maiming122912723_m_aiming
malling103623663_m_alling
malting103219083_m_alting
misaiming1437873misaiming
napalming1443173napalming
palming123914013__palming
pinballing1544013pinballing
psalming1375473_psalming
unbaling11310683unbal_ing
wimbling16186543wimb_l_ing

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 Filter1786911486410.403443402.0
2DLD Change Limit148641617.11020905.9
3Display Results61610.0331848.5
 (SQL Overall)178691617.54623680.2
 
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.