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

58 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
snappishnesses205226(None) 
snappinesses1684322snappi__nesses
snappishness1952282snappishne_s_s
apishnesses1646373__a_pishnesses
foppishnesses2343393_foppishnesses
nappinesses1555923_nappi__nesses
sappinesses1567563s_appi__nesses
sheepishnesses2153013sheepishnesses
slavishnesses1843673sla_vishnesses
sniffishnesses2272203sniffishnesses
snobbishnesses2051773snobbishnesses
swainishnesses1952323swainishnesses
uppishnesses1943603__uppishnesses
waspishnesses2043283_waspishnesses
bearishnesses1844844bea_rishnesses
blimpishnesses2382144blimpishnesses
brackishnesses2552644brackishnesses
caddishnesses2043374_caddishnesses
clannishnesses1952984clannishnesses
dwarfishnesses2492134dwarfishnesses
faddishnesses2143244_faddishnesses
garishnesses1645884_ga_rishnesses
gawkishnesses2443034_gawkishnesses
happinesses1876164_happi__nesses
hawkishnesses2643254_hawkishnesses
impishnesses1944294__impishnesses
lavishnesses1844774_la_vishnesses
lumpishnesses2043474_lumpishnesses
mannishnesses1873964_mannishnesses
mawkishnesses2543134_mawkishnesses
nippinesses1545064_nippi__nesses
oafishnesses1844764_oa_fishnesses
prankishnesses2353204prankishnesses
qualmishnesses2852074qualmishnesses
raffishnesses2243224_raffishnesses
rakishnesses1944984_ra_kishnesses
saplessnesses1347264s_aplessnesses
scrappinesses1952294scrappi__nesses
selfishnesses1844044s_elfishnesses
shrewishnesses2262244shrewishnesses
sickishnesses2143664s_ickishnesses
skittishnesses2052394skittishnesses
sloppinesses1644054sloppi__nesses
sluggishnesses1852144sluggishnesses
sluttishnesses1652684sluttishnesses
snakinesses1538554sna_ki__nesses
snappiness1443824snappi__ne_s_s
soapinesses1339704soa_pi__nesses
soppinesses1566844s_oppi__nesses
sottishnesses1544444s_ottishnesses
squarishnesses2552424squarishnesses
stylishnesses1843404s_tylishnesses
swampinesses1943714swampi__nesses
swinishnesses1843654s_winishnesses
unhappinesses2052484unhappi__nesses
vaporishnesses2252234_vaporishnesses
waggishnesses2143284_waggishnesses
wimpishnesses2343584_wimpishnesses

Search took 5 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 Filter178691658740.1401276364.3
2DLD Change Limit65874584.11016027.7
3Display Results58580.0461260.9
 (SQL Overall)178691584.29641594.7
 
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.