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

160 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
hophead1633792(None) 
hopheads17276601hopheads
hothead14349291hothead
bowhead1636432bowhead
cohead123811122co_head
dopehead1544072dopehead
drophead1544612drophead
godhead1334762godhead
hogshead1673922hogshead
hoped115628182hop_e_d
hopped144318112hoppe_d
hoptoad1344322hoptoad
hotheads15318012hotheads
pothead133810392pothead
saphead1357772saphead
towhead1435222towhead
ahead96817053__ahead
airhead1136993airhead
behead1239923_behead
bighead14126653bighead
bohea105013733bo_hea_
boheas114013213bo_heas
bolthead1445903bolthead
bonehead1445933bonehead
bopped134413403boppe_d
bowheads1745373bowheads
cathead1338753cathead
cepheid1545433cepheid
chopped174511003choppe_d
coheads13289233co_heads
cokehead1845063cokehead
colead94114643co_lead
coped105036843cop_e_d
copied114618563copie_d
copped135221253coppe_d
copyread1643783copyread
coshed124217543coshe_d
cowherd1636953cowherd
doped95326713dop_e_d
dopeheads1644143dopeheads
dropheads1643873dropheads
egghead1343433egghead
fathead1437863fathead
fopped144012673foppe_d
forehead1537893forehead
godheads1443983godheads
gopher1239183gophe_r
gophers1338983gophers
happed144820103happe_d
hardhead1645883hardhead
hashed136021943hashe_d
hashhead1443263hashhead
head87137173___head
heptad1237273hep_tad
hipped144317693hippe_d
hoaxed17378873hoaxe_d
hobbed144114303hobbe_d
hoboed124511683hoboe_d
hocked165521303hocke_d
hodad10311353ho__dad
hoed87837983ho__e_d
hogged125817773hogge_d
hogsheads1773663hogsheads
hogweed1534443hogweed
hoised105117433hoise_d
hoked135326993ho_ke_d
holed95634133ho_le_d
holked144913663holke_d
hollaed11359853hollaed
homed115425423ho_me_d
honed95332263ho_ne_d
honied104818393honie_d
honked144517913honke_d
hooded114616743hoode_d
hoofed134614893hoofe_d
hooked145320553hooke_d
hooped125518183hoope_d
hooted104422663hoote_d
hooved134713123hoove_d
hope96639673hop_e__
hoper105829143hop_e_r
hopers114222973hop_ers
hopes105835643hop_e_s
hopper134218483hoppe_r
hoppers143115143hoppers
hoppled15338083hoppled
hoptoads1444143hoptoads
horded115420483horde_d
horned105718703horne_d
horsed105321083horse_d
hosed95830983ho_se_d
hosted105020343hoste_d
hotbed123310683hotbe_d
hotched163610923hotche_d
hotheaded1744853hotheaded
hotted104319943hotte_d
housed105624103house_d
howked177312343howke_d
howled134014963howle_d
humphed1835423humphe_d
hushed134416673hushe_d
hyped145313333hyp_e_d
hypha1637383hyph_a_
hyphae1746433hyph_ae
hyphal1736413hyph_al
hyphen1736393hyphe_n
hyphened2044683hyphened
hyphens1836043hyphens
hypoed1547923hypoe_d
implead12315823implead
jarhead1835173jarhead
joshed174610903joshe_d
jughead1933643jughead
lipread1034953lipread
longhead1345083longhead
loped85128333lop_e_d
lopped114218623loppe_d
moped105424733mop_e_d
mopped134114323moppe_d
morphed1537133morphe_d
moshed124517493moshe_d
noshed104413503noshe_d
ohed87825183_o_he_d
oohed94214213_oohe_d
oped76230153_op_e_d
opted84914273_opte_d
oread64619603_o_read
pinhead13347073pinhead
pithead13419593pithead
plead85818463__plead
plowhead1742803plowhead
poohed123912523poohe_d
popped104117813poppe_d
poppyhead1951503poppyhead
potheads14298543potheads
redhead1257053redhead
replead10399003replead
roped84630803rop_e_d
sapheads1466083sapheads
sheephead1863893sheephead
shepherd1744373shepherd
shithead1535523shithead
shophar1555463shoph_ar
shopped153512213shoppe_d
shorthead1644473shorthead
softhead1545003softhead
sopped114819903soppe_d
sorehead1246973sorehead
spread9312533_spread
subhead1387693subhead
toolhead1244353toolhead
toped85631313top_e_d
tophe106718973tophe__
tophes115218423tophe_s
topped114617723toppe_d
towheads1544813towheads
upheap13105213_upheap
upheld12115563_upheld
warhead1436603warhead
whopped18358003whoppe_d

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271606.79619721.5
3Display Results1601600.0463478.3
 (SQL Overall)1786911606.98225593.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.