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

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

49 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
featherheaded246186(None) 
featherbedded2471602featherbedded
featherhead2153072featherhea__d
featherheads2252592featherhead_s
featheredged21102053feather_edged
fatheaded1744274f_at___headed
featherbed19174664feather___bed
featherbeds20193574featherbe_d_s
featherbrained2371554featherbrained
feathered16188894feather____ed
featheredge1972714feather_e_dge
featheredges2072604feather_edges
leatherleaves1961474leatherleaves
rethreaded1543274re_th_r_eaded
weatherboarded2471504weatherboarded
airheaded1443955__a__irheaded
bareheaded1763955_ba_re_headed
chowderheaded2761035chowderheaded
clearheaded1851715clea___rheaded
deadheaded1742835dea___dheaded
dunderheaded1952045_dunderheaded
fathered151510435f_ather____ed
fatherhood2053295f_atherh__ood
fatherhoods2153035f_atherhood_s
fatherland1753005f_ather_la_nd
featherbedding25111435featherbedding
featherbrain20122345featherbra_in
featherbrains21132245featherbrains
featherier1645805feather___ier
featheriest1745695featherie__st
featherless1743915featherle__ss
featherweight26132105featherweight
heathered16149465heather____ed
leathered13148715leather____ed
leatherette1452995leather_ette_
leatherettes1552605leather_ettes
leatherleaf17262265leatherlea__f
letterhead1442365le_tterhea__d
letterheads1552155le_tterhead_s
levelheaded1951415le__velheaded
retreaded1137055re_t__r_eaded
spearheaded1851835spea___rheaded
threaded1366325___th_r_eaded
unthreaded1543535_unth_r_eaded
waterhead1644405_wat_erhea__d
waterheads1744245_wat_erhead_s
weatherboard2152965weatherboa_rd
weathered16168515weather____ed
weatherized2745175weather__ized

Search took 10 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 Limit124790499.06313769.2
3Display Results49490.0331484.8
 (SQL Overall)178691499.48618837.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.