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

53 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
mightiness164509(None) 
almightiness1851912almightiness
flightiness1843892flightiness
lightness13107432light_ness
mightiest1546442mighti_est
mightinesses1844382mightinesses
mistiness111911632mi_stiness
rightness13117352right_ness
sightliness1574562sightliness
tightness1386602tight_ness
weightiness1843262weightiness
bittiness11228333bi_ttiness
brightness1644573bright_ness
dirtiness1039473di_rtiness
doughtiness1642703doughtiness
eighties12710803eighti_e_s
fidgetiness1651913fidgetiness
fightings17276503fightin_gs
filthiness1643713filthiness
fishiness1537343fish_iness
haughtiness1842233haughtiness
highness1536053high__ness
knightliness2052733knightliness
lighteners1444983lighteners
lightings14277723lightin_gs
lightless1386073light_less
maltiness112910573m_altiness
matiness102114743m__atiness
meatiness11311173m_eatiness
miffiness1734523mi_ffiness
mightier1436383mighti_e_r
migraines1286933migraine_s
milkiness1536523mi_lkiness
minuteness1245293minuteness
miriness10310463mi__riness
mugginess1354633mug_giness
mushiness14248223mush_iness
mustiness112211663m_ustiness
naughtiness1542383naughtiness
niftiness1236363ni_ftiness
nighness1236103nigh__ness
nightdress1552983nightdress
nighties121011383nighti_e_s
nightless1386073night_less
pigginess1375453pig_giness
pithiness1437563pith_iness
righties12711573righti_e_s
sightings14256533sightin_gs
sightless1385923sight_less
sightlines1465753sightline_s
slightness1454803slight_ness
tighteners1444043tighteners
wittiness12197223wi_ttiness

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603538.06317438.1
3Display Results53530.0301766.7
 (SQL Overall)178691538.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.