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 “forehead” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
forehead153789(None) 
foreheads1647031foreheads
sorehead1246971sorehead
barehead1446602barehead
bonehead1445932bonehead
cokehead1845062cokehead
dopehead1544072dopehead
forebear1346382forebear
forefend1545602forefend
forehand1537692forehand
forepeak17134782forepeak
soreheads1346072soreheads
aforehand1642813aforehand
airhead1136993air_head
behead1239923__behead
bluehead1444603bluehead
bolthead1445903bolthead
boneheads1545203boneheads
bowhead1636433bo_whead
cohead123811123co__head
cokeheads1944473cokeheads
dopeheads1644143dopeheads
drophead1544613drophead
fathead1437863f_athead
figurehead1851033figurehead
fireweed1545353fireweed
flathead1535813flathead
foraged124812283forage_d
forayed14368593foraye_d
forbad122710503for__bad
forbear1237523for_bear
forced126316523for_ce_d
forcemeat1644253forcemeat
forded115020393for_de_d
forebay1538133fore_bay
forebears1446413forebears
forecheck2342773forecheck
foredeck1874353foredeck
foredid1238503fore_did
forefeel14105513forefeel
forefeet14129393forefeet
forefelt14117363forefelt
forefends1644493forefends
forehands1656743forehands
forehoof1746603forehoof
forelady1545073fore_lady
foreland1239013foreland
foreleg1137743forele_g
forelegs1236613forelegs
foreman12312363fore_man
foremen12412923foreme_n
forepaw1595613fore_paw
forepeaks18104573forepeaks
foreplay1645673foreplay
foreran10311793fore_ran
forereach1743663forereach
foresaid1247803foresaid
foresaw1377133fore_saw
foresee10414333forese_e
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foresheet1549233foresheet
forespeak1843473forespeak
forestal11410283forestal
forestay1448193forestay
forested12312463forested
foreswear1543513foreswear
foretell1146123foretell
foretold1256493foretold
forever1338953foreve_r
forevers1438173forevers
forewent1439423forewent
foreword15118963foreword
foreyard1546423foreyard
forfend1435413for_fend
forged115519323for_ge_d
forked145217143for_ke_d
formed125021173for_me_d
forswear1443293forswear
foureyed1543663foureye_d
freed95223543f_re_e_d
freehand1574993f_reehand
freshed143312593f_reshe_d
frothed14288783frothe_d
godhead1334763go_dhead
hardhead1645883hardhead
hogshead1673923hogshead
hophead16337923ho_phead
hothead14349293ho_thead
jarhead1835173jar_head
longhead1345083longhead
morphed1537133morphe_d
oread64619603_or__ead
overhead152110363_overhead
pothead133810393po_thead
preheat12413893_preheat
redhead1257053__redhead
rehear93713223__rehear
reheard11309023__reheard
reheat94423943__reheat
reread71715433__reread
scarehead1543803scarehead
shorthead1644473shorthead
softhead1545003softhead
soreheaded1544303soreheaded
toolhead1244353toolhead
torched133511363torche_d
towhead1435223to_whead
warhead1436603war_head
worthed1437873worthe_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 Filter1786911461620.533335255.2
2DLD Change Limit1461621117.59319249.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.17221866.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.