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

54 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
abdominally195253(None) 
abdominal1453062abdomina_l_
abdominals1552182abdomina_ls
abominably1952632ab_ominably
abdomina1343963abdomina___
abiotically1849073abiotically
abominable1643143ab_ominable
atomically1749873a_tomically
domically1749103__domically
nominally1446803__nominally
abnormally1752744abno_rmally
abominate1347024ab_omina_te
abominated1545204ab_ominated
abominates1446514ab_ominates
abominator1444204ab_ominator
aborally1347064ab_o__rally
aboriginally1851794aboriginally
abysmally1951814abysm__ally
academically2253724academically
actinally1448234a__ctinally
additionally1753314additionally
admirably1743884a_d_mirably
admiralty1552244a_d_miralty
adoringly1445424a_dorin_gly
adrenally1344944a_d_renally
aerobically1848114aerobically
alogically1648794a_logically
ambrosially1852104ambrosi_ally
anatomically1956174anatomically
anemically1748904a_nemically
anodically1648264a_nodically
armorially1544924armori_ally
atonally1148634a_to__nally
autumnally1552064autum_nally
binomially1753664binomi_ally
boomingly1744794_boomin_gly
cardinally1645404card__inally
comically18310524__comically
criminally1746194_criminally
dominancy1744154__dominancy
dominantly1653424__dominantly
endemically1945984endemically
geminally1576404__geminally
germinally1655254_germinally
hebdomadally246574hebdomadally
hedonically2046884hedonically
indomitably1955044indomitably
medicinally1953284medicinally
ordinally1346294ord__inally
pronominally1954164pronominally
sardonically1855294sardonically
seminally1458804__seminally
subliminally1951934subliminally
terminally1567024_terminally

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.423422437.4
2DLD Change Limit148819548.51617475.2
3Display Results54540.0301800.0
 (SQL Overall)178691548.96919923.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.