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

78 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
crookedness185241(None) 
crookedest1752572crooked_est
crookednesses2052612crookednesses
crowdedness1852992crowdedness
rootedness1144902_rootedness
brokenness1643323br_okenness
crabbedness1852363crabbedness
crookeder1642823crooked_e_r
crookeries1646133crookerie_s
hoodedness1544563_hoodedness
uprootedness1562693uprootedness
broadness1256664br_o_adness
broodiness1344654broo_diness
broodless1235034broo__dless
choiceness1743774choice_ness
closeness1137614c_lose_ness
cockeyedness2461834c_ockeyedness
cockiness17248784c_ock_iness
coldness1137954c__o_ldness
composedness1952394composedness
cookeries151210634c_ookerie_s
cookless14258634c_ook__less
coolness1037744c_oo__lness
corkiness152810444c_ork_iness
crankiness1636174crank_iness
cravenness1543884cr_avenness
creakiness1645964creak_iness
croceines1347734cr_oceine_s
crockeries1857114crockerie_s
crooked143910944crooked____
crookedly1942034crooked__ly
crookest1436684crook___est
crookneck1651334crook__neck
crooknecks1751344crook__necks
crooners103911394croo___ners
crossness1137094cr_o_ssness
crowdednesses2053184crowdednesses
crowkeepers2251814crowkeepers
crudeness1245754cr_ude_ness
cruelness1145054cr__uelness
cursedness1344464c_ursedness
cussedness1342844c_ussedness
devotedness1653704devotedness
doggedness1443514_doggedness
drunkenness1651564drunkenness
frowardness1852894frowardness
frozenness2242684fr_ozenness
goodness1036254_goo__dness
gooeyness1343544_goo_eyness
hokeyness1943804__hokeyness
hornedness1445404_hornedness
kookiness1235564_kook_iness
looseness937474_loose_ness
markedness1744024_markedness
moroseness1246214morose_ness
nakedness1445044__nakedness
notedness1047324__notedness
peakedness1744864_peakedness
profoundness1851614profoundness
proneness11310444pr_one_ness
properness1445924pr_operness
proudness1246694pr_o_udness
raggedness1344154_raggedness
redness82012444_r___edness
rockiness15237834_rock_iness
rookeries13138174_rookerie_s
roominess1157304_roo_miness
rootednesses1345334_rootednesses
rootiness979064_roo_tiness
rottenness1043764_rottenness
rotundness1143404_rotundness
roundedness1354294_roundedness
roundness1047014_r_oundness
ruggedness1343264_ruggedness
spookiness1644434spook_iness
wickedness2043074_wickedness
wontedness1445504_wontedness
woodenness1443724_woodenness

Search took 9 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 Filter1786911488190.436409841.7
2DLD Change Limit148819787.93618752.4
3Display Results78780.0461695.7
 (SQL Overall)178691788.41821227.3
 
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.