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 “millionairesses” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

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
millionairesses17786(None) 
millionairess1581702millionaire_s_s
millionaires1472993millionair___es
billionaires1472954billionair___es
millionaire1372924millionair___e_
zillionaires2182004zillionair___es
billionaire1372645billionair___e_
hillinesses1458505hilli_n___esses
militantnesses1661875mi_litantnesses
milkinesses1786795milki_n___esses
sillinesses1169845silli_n___esses
villainesses1543515vill___ainesses
visionarinesses1861665vi_sionarinesses
willingnesses1753175willi_n_gnesses
zillionaire2081785zillionair___e_
biliousnesses1547296bi_lio_usnesses
chillinesses1744986chilli_n___esses
debonairnesses1771446__debonairnesses
dilatorinesses1552056dilato_rinesses
filminesses1636236filmi_n___esses
flintinesses1546326__fli_ntinesses
illiberalnesses1791556_illiberalnesses
illnesses937286_ill__n___esses
illusorinesses1461656_illusorinesses
imaginarinesses1861676imagi_narinesses
jollinesses1836726jolli_n___esses
liltingnesses1453576lilti_n_gnesses
lionesses939436___lion___esses
looninesses1197996___loon_inesses
maltinesses13310236malti_n___esses
manlinesses13910196manli_n___esses
mealinesses13310976meali_n___esses
mellownesses1752056mell_o__wnesses
miffinesses1944366miffi_n___esses
mildnesses1397396mi_l_dn___esses
militarises1366506mi_li_ta_r_ises
millenaries1355526mill_ena_r__ies
milliamperes1861346milli__ampe_res
milliares1149406milli__a_r___es
milliaries1248246milli__a_r__ies
millidegrees1661146milli_degre__es
millineries1355486milli_n___eries
minidresses1443286m___i_nidresses
mirinesses121512316mi_ri_n___esses
missionaries1453626missiona_r__ies
mistinesses131310626misti_n___esses
moldinesses14138046moldi_n___esses
mooninesses13127946m___oon_inesses
oilinesses101512446oi_li_n___esses
pallidnesses1543926pallidn___esses
rationalnesses1452636_rationalnesses
silkinesses1557906silki_n___esses
slinkinesses1645816__sli_nkinesses
wilinesses131911096wi_li_n___esses

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024546.45314725.6
3Display Results54540.0301800.0
 (SQL Overall)178691546.84326113.0
 
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.