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

81 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
ambassadresses18764(None) 
ambassadress176862ambassadre_s_s
absurdnesses1562725a_b_surdnesses
ambassadors1661315ambassad___ors
ambassadorship24221175ambassadorship
ambassadorships25221145ambassadorships
bassnesses1136845__bass__nesses
massinesses12128695_m_ass_inesses
misaddresses1651695_m_isaddresses
abrasivenesses19105556abrasivenesses
abscesses1344106a_b__s__cesses
abusivenesses1856296a_busivenesses
accursednesses1961776accursednesses
adaptednesses1772626a_daptednesses
addresses1165636___a__ddresses
aimlessnesses1487466aimless__nesses
albatrosses1351466alb___atrosses
amativenesses1856786am_ativenesses
ambassador1551386ambassad____or
ambassadorial18111096ambassad_orial
ambuscaders1861576ambuscad_e__rs
ambuscades1752276ambuscad____es
amiablenesses1756536amia_blenesses
amusingnesses1652846am_usingnesses
ancestresses1493276a_nces_tresses
arbitresses1343346arb___itresses
assesses737386___ass___esses
aviatresses1483006___aviatresses
badnesses1239256__b___adnesses
baldnesses1337656__ba__ldnesses
basenesses12310566__ba_s_enesses
bastardises1473486__basta_rdises
blessednesses1552856_blessednesses
bossinesses12117356__boss_inesses
brassinesses1346066_brass_inesses
broadnesses1446196__b_roadnesses
casualnesses1443786__casualnesses
classinesses1366116_class_inesses
coatdresses1443946_coa__tdresses
crassnesses1246656_crass__nesses
cussednesses1443536__cussednesses
embarrasses1562006emb___arrasses
embassages1551846embassa____ges
gassinesses1197976__gass_inesses
glassinesses1255246_glass_inesses
headdresses1683696_hea__ddresses
housedresses1652706__housedresses
impassableness2063236impassableness
impassivenesses2164126impassivenesses
laundresses1243116__la_undresses
madnesses1239836_m____adnesses
manageresses1552216_m_anageresses
markednesses1944186_m_arkednesses
marshinesses1744966_m_arshinesses
massacrers1442286_m_assacre__rs
massacres1344696_m_assacr___es
masseuses1144796_m_ass___euses
massivenesses1755916_m_assivenesses
mattresses1245436_m_a__ttresses
mayoresses1543696_m_a__yoresses
mazednesses2345406_m_a_zednesses
messinesses1297516_m_ess_inesses
minidresses1443286_m__inidresses
misaddressed1761246_m_isaddressed
mistresses1247996_m__is_tresses
mossinesses12117466_m_oss_inesses
mussinesses12147446_m_uss_inesses
pantdresses1443756__pa_ntdresses
readdresses1394516_rea__ddresses
reassesses945066_reass___esses
sadnesses10310306_____sadnesses
sassafrases1351086__sassafr_ases
sassinesses999326__sass_inesses
seamstresses1352256_seams_tresses
subacidnesses1851696suba_cidnesses
sundresses1146546____sundresses
sweaterdresses186646sweaterdresses
transgresses1354156_trans_gresses
unbiasednesses17102696unbiasednesses
unwashednesses21112146unwashednesses
wardresses1445416__wa__rdresses

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790818.90314016.6
3Display Results81810.0501620.0
 (SQL Overall)178691819.35919093.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.