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

42 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
unharness124525(None) 
harness102413932__harness
nearness838312_nearness
unfairness1342812unfairness
unharnessed1553402unharnessed
unharnesses1445432unharnesses
unwariness1365882unwariness
chariness14310063_chariness
charnels13328173_charnels
clearness1135633clearness
dearness939973_dearness
farness102912203__farness
hardness122411083__hardness
innerness946913innerness
inverness1247133inverness
inwardness1443773inwardness
neatness839153_neatness
otherness1245513otherness
sharpness1434943_sharpness
unaptness1154173unaptness
unawareness1453693unawareness
uncharges1546213uncharge_s
undress838893un_dr_ess
unearned9310063unearne_d
uneasiness1046393uneasiness
unfitness1244843unfitness
unhairers12183273unhairers
unhandiness1563953unhandiness
unhands1137773unha_n_ds
unhangs1136203unha_n_gs
unhappiness1852293unhappiness
unharmed1438093unharme_d
unharnessing1651283unharnessing
unholiness1344983unholiness
unhorses1138453unhorse_s
unstress837373unstr_ess
unwariest1246033unwariest
unwarned1238453unwarne_d
upwardness1642653upwardness
usualness993563usualness
utterness946223utterness
whatness1435093_whatness

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.420425454.8
2DLD Change Limit148641426.33023482.0
3Display Results42420.0162625.0
 (SQL Overall)178691426.76626410.1
 
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.