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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
drollness104362(None) 
drollest937352droll_est
drollnesses1244362drollnesses
dullness934872d_ullness
adroitness1153053adroitness
boldness1136973_boldness
broadness1256663broadness
brollies1039533brollie_s
browless1346653browl_ess
brownness1444343brownness
chillness1455373chillness
coldness1137953_coldness
coolness1037743_coolness
cropless1237793cropl_ess
crossness1137093crossness
crownless1443423crownless
cruelness1145053cruelness
dailiness1038673dailiness
dailyness1343643dailyness
dollies83620983d_ollie_s
doneness9411513d_oneness
doorless936713doorl_ess
dopiness11289973d_opiness
dorkiness14248053dorkiness
dourness947683d_ourness
downless1236363d_ownless
doziness18228553d_oziness
drabness1135803dr_abness
drillers9429723drill_ers
dripless1135243dripl_ess
drolled93810223droll_e_d
droller84110283droll_e_r
drollery12314793droll_ery
drolls75312393droll___s
droners84114383dro__ners
drones75023433dro__ne_s
drooliest1036343drooliest
droplets1136063dropl_ets
drowners12428273dro_wners
drowsiness1443643drowsiness
dryness11114783dr__yness
dulness8307983d__ulness
fellness1135913_fellness
foulness11236653_foulness
frailness1236543frailness
fullness1135443_fullness
grossness1045963grossness
growliness1494073growliness
holiness112512503_holiness
illness736473__illness
ironness836953iro_nness
jolliness1636213_jolliness
oldness836403__oldness
prolines102619693proline_s
proneness11310443proneness
prosiness11311683prosiness
proudness1246693proudness
realness8410443_realness
rodless8310073_rodl_ess
rollers73117473_roll_ers
ropiness102311073_ropiness
rosiness82613173_rosiness
shrillness1343223shrillness
smallness1174513smallness
soleness8814263_soleness
stillness936103stillness
tallness837103_tallness
toolless836343tooll_ess
trollers83211213troll_ers
trolleys11315693troll_eys
trollies8310233trollie_s
wellness1135793_wellness
wholeness1545373wholeness
wooliness12147693wooliness
woolliness1343563woolliness
wrongness1344513wrongness

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 Filter1786911486410.423422437.4
2DLD Change Limit148641766.45323034.4
3Display Results76760.0302533.3
 (SQL Overall)178691766.90625874.7
 
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.