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

51 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
shorthead164447(None) 
shortheads1743811shortheads
hothead14349292_ho_thead
shithead1535522sh_ithead
shortbread16132082shortbread
shorted113614402short_e_d
shorthand1643752shorthand
softhead1545002s_ofthead
sorehead1246972s_orehead
bolthead1445903_bolthead
chortled14326613chortle_d
forehead1537893_forehead
hardhead1645883_hardhead
hogshead1673923_hogshead
hophead16337923_ho_phead
hotheads15318023_ho_theads
pothead133810393_po_thead
scarehead1543803scarehead
scorched16187203scorche_d
sheathed1547223sheathe_d
sheephead1863893sheephead
shitheads1645043sh_itheads
shored105723653shor__e_d
shortbreads17131983shortbreads
shorten103511413short_e_n
shortened1345663shortened
shortens11288993short_ens
shorter103515503short_e_r
shortest11310783short_est
shorthair1543023shorthair
shorthands1743493shorthands
shorthorn1543993shorthorn
shortia1048193short_ia_
shortias1148093short_ias
shortie10411343shortie__
shorties11414583shortie_s
shortness1236733shortness
shotted113912403sho_tte_d
shouted113911553shout_e_d
showbread1842303showbread
showerhead2051953showerhead
smoothed14236473smoothe_d
snorted83813493snort_e_d
softheads1644553s_oftheads
soothed113712743s_oothe_d
soreheads1346073s_oreheads
sorted74523713s_ort_e_d
sortied83314103s_ortie_d
southed114313993s_outhe_d
sported104015433sport_e_d
worthed1437873_worthe_d

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 Filter1786911486410.940190096.8
2DLD Change Limit148641517.57619620.0
3Display Results51510.0163187.5
 (SQL Overall)178691518.53220943.6
 
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.