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

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

56 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
underhandedness217181(None) 
evenhandedness2272284_evenhandedness
forehandedness2262824fore_handedness
freehandedness2262194_freehandedness
openhandedness2162454_openhandedness
underhanded1744664underhanded____
underhandedly2261764underhanded__ly
handedness1545905_____handedness
hardhandedness2372105_hardhandedness
offhandedness2462265__offhandedness
strandedness1453695__str_andedness
unboundedness1762245un__boundedness
undeniableness1764295undeniable_ness
underhands1545455underhan__d___s
unguardedness1662625un__guardedness
unhandiness1563955un___hand_iness
unpreparedness1961975unprepa_redness
beardedness1544596__be__ardedness
boneheadedness2163486bone_headedness
clearheadedness22102136clearheadedness
decidedness16103796__de__cidedness
dementedness1654676__de_mentedness
depravedness1952796__depra_vedness
detachedness1952526__de_tachedness
detailedness1453196__de_tailedness
determinedness1861706determin_edness
extendedness2152776___extendedness
indebtedness1654526inde___btedness
levelheadedness2381966levelheadedness
moderateness1565286moder_a_te_ness
mundaneness1453446mund___an_e_ness
newfangledness227666_n_ewfangledness
nonrandomness1661406_nonr_andomness
pinheadedness2064176pinhe__a_dedness
roundedness1354296____roundedness
roundheadedness2172436round__headedness
sobersidedness18101636sober_sidedness
unbiasedness1552616un__bia_sedness
uncertainness1572336uncerta__inness
unchasteness1773286un__chaste_ness
underbidders1751636under_bid_d_ers
underfunded1763356underfunded____
undergarments1762806undergarme_n_ts
underhand1447266underhan__d____
underlayments1972646underlayme_n_ts
undermanned1544186underman___ne_d
underpayments2162506underpayme_n_ts
understandings17112376understand_in_gs
undesirableness18103626undesirable_ness
unexpectedness2672316un_expectedness
unfriendliness186916un_friendliness
unreadiness1244656un__rea_d_iness
unreservedness1891956unre_servedness
unsettledness1462446unse__ttledness
unwashedness1952146un___washedness
unwontedness1683456un___wontedness

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 Filter178691950240.376475242.0
2DLD Change Limit95024567.51312647.9
3Display Results56560.0461217.4
 (SQL Overall)178691567.93522519.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.