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

65 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
prankishnesses235320(None) 
brackishnesses2552642brackishnesses
pinkishnesses2243982p_inkishnesses
prankishness2153052prankishne_s_s
rakishnesses1944992_ra_kishnesses
clannishnesses1952983clannishnesses
crankinesses1846143cranki__nesses
freakishnesses2452653freakishnesses
gawkishnesses2443033_gawkishnesses
hawkishnesses2643253_hawkishnesses
mannishnesses1873963_mannishnesses
mawkishnesses2543133_mawkishnesses
priggishnesses2152373priggishnesses
prudishnesses1943673pr_udishnesses
puckishnesses2443333p_uckishnesses
raffishnesses2243223_raffishnesses
trickishnesses2352503trickishnesses
apishnesses1646374__a_pishnesses
bearishnesses1844844bea_rishnesses
bookishnesses2263684_bookishnesses
brackishness2352454brackishne_s_s
brashnesses1646554bra___shnesses
brutishnesses1844094br_utishnesses
caddishnesses2043374_caddishnesses
donnishnesses1784114_donnishnesses
dwarfishnesses2492134dwarfishnesses
faddishnesses2143244_faddishnesses
faintishnesses2053304faintishnesses
fiendishnesses2172474fiendishnesses
folkishnesses2343924_folkishnesses
franknesses1845604frank___nesses
franticnesses1843674franti_cnesses
garishnesses1645884_ga_rishnesses
grandiosenesses1781854grandiosenesses
greenishnesses1882964greenishnesses
lankinesses1539014_lanki__nesses
lavishnesses1844774_la_vishnesses
oafishnesses1844774_oa_fishnesses
pawkinesses2036154p_awki__nesses
peevishnesses2143474p_eevishnesses
pettishnesses1844384p_ettishnesses
piggishnesses2043284p_iggishnesses
pinkishness2043834p_inkishne_s_s
planlessnesses1576304planlessnesses
precisenesses1756284pr_ecisenesses
punkinesses17127224p_unki__nesses
qualmishnesses2852084qualmishnesses
rakishness1744614_ra_kishne_s_s
rancidnesses1544884_ranci_dnesses
randinesses121311204_randi__nesses
ranginesses121210114_rangi__nesses
ranknesses1438094_rank___nesses
rashnesses1338724_ra___shnesses
reddishnesses1873584_reddishnesses
roguishnesses1763974_roguishnesses
ruttishnesses1644044_ruttishnesses
sickishnesses2143664_sickishnesses
slavishnesses1843684sla_vishnesses
snappishnesses2052264snappishnesses
swainishnesses1952324swainishnesses
swankinesses1944784swanki__nesses
swinishnesses1843654swin_ishnesses
waggishnesses2143284_waggishnesses
waspishnesses2043284_waspishnesses
womanishnesses2252824woman_ishnesses

Search took 8 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.640279204.7
2DLD Change Limit65874656.37610331.6
3Display Results65650.093698.9
 (SQL Overall)178691657.10925135.9
 
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.