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

72 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
prankishness215305(None) 
brackishness2352452brackishness
pinkishness2043832p_inkishness
prankishnesses2353202prankishnesses
rakishness1744612_ra_kishness
clannishness1752813clannishness
crankiness1636173cranki__ness
freakishness2252473freakishness
gawkishness2243073_gawkishness
hawkishness2443273_hawkishness
mannishness1643973_mannishness
mawkishness2343033_mawkishness
priggishness19112283priggishness
prudishness1743573pr_udishness
puckishness2243243p_uckishness
raffishness2043373_raffishness
trickishness2152523trickishness
apishness1445744__a_pishness
bearishness1644544bea_rishness
bookishness2043694_bookishness
brackishnesses2552644brackishnesses
brandishes1645894brandish_e_s
brashness1436324bra___shness
brutishness1643554br_utishness
caddishness1843414_caddishness
donnishness1543894_donnishness
dwarfishness2292024dwarfishness
faddishness1943244_faddishness
faintishness1863064faintishness
fiendishness1952334fiendishness
folkishness2143834_folkishness
frankness1655224frank___ness
franticness1643604franti_cness
garishness1445744_ga_rishness
grandioseness15122554grandioseness
greenishness1653154greenishness
lankiness1338054_lanki__ness
lavishness1644714_la_vishness
oafishness1644464_oa_fishness
panfishes1737594p_anfish_e_s
pawkiness1835444p_awki__ness
peevishness1943144p_eevishness
pettishness1643974p_ettishness
piggishness1873144p_iggishness
pinkishnesses2243984p_inkishnesses
planishers1584774plan_ish_ers
planishes14138524plan_ish_e_s
planlessness1444994planlessness
prankish1737024prankish____
prankishly2242414prankish__ly
pranksters1653284prank_s_ters
preciseness1545784pr_eciseness
punkiness15226984p_unki__ness
qualmishness2652174qualmishness
rakishnesses1944994_ra_kishnesses
rancidness1344224_ranci_dness
randiness102511444_randi__ness
ranginess101610214_rangi__ness
rankness12267944_rank___ness
rashness1138094_ra___shness
reddishness1643434_reddishness
roguishness1563634_roguishness
ruttishness1443614_ruttishness
sickishness2043654_sickishness
slavishness1753704sla_vishness
snappishness1952284snappishness
swainishness1852294swainishness
swankiness1744254swanki__ness
swinishness1743574swin_ishness
waggishness1943024_waggishness
waspishness1943084_waspishness
womanishness2052704woman_ishness

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 Filter1786911247900.390458182.1
2DLD Change Limit124790727.20317324.7
3Display Results72720.0332181.8
 (SQL Overall)178691727.62623431.8
 
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.