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

147 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
goatherd133526(None) 
goatherds1444201goatherds
gather104115852g_ather_
gathered13149372g_athered
gathers114315072g_athers
goateed9307062goat_eed
loathed11419442loathe_d
loather103711002loather_
loathers113310442loathers
neatherd12107192neatherd
bathed125518743_bathe_d
bather115322513_bather_
bathers124720363_bathers
blather125314203blather_
blathered15168353blathered
blathers134713793blathers
boated94221973boat_e_d
boater84622093boat_er_
boaters93419243boat_ers
boatyard1444073boatyard
bolthead1445903bolthead
bother115218063bo_ther_
bothered142110393bo_thered
bothers124317753bo_thers
cathead1338753_cathead
coached153313843coache_d
coacher143714123coacher_
coachers154312303coachers
coated94927043coat_e_d
coater84329573coat_er_
coaters93525793coat_ers
coattend1134653coattend
couther123914633couther_
cowherd1636953co_wherd
doated84118183doat_e_d
fathead1437863_fathead
father125116713_father_
fathered151510433_fathered
fathers133916503_fathers
feather133613503feather_
feathered16188893feathered
feathers143513243feathers
feathery17368073feathery
flathead1535803flathead
gashed116321973g_ashe_d
gasher104320373g_asher_
gated75329773g_at_e_d
gater64533653g_at_er_
gaters74728643g_at_ers
gatherer12147903g_atherer
gearhead1344433gearhead
gilthead1343323gilthead
girthed12266243girthe_d
gloated93511533gloat_e_d
gloater83711013gloat_er_
gloaters9288863gloat_ers
gnashed12317523gnashe_d
goaded94913713goa_de_d
goaled85014363goa_le_d
goalward1343493goalward
goatee73219533goat_e_e
goatees82710443goat_ees
godfather1742173godfather_
godfathered2051413godfathered
godfathers1852163godfathers
godhead1334763go_dhead
goiter74116203goit_er_
goiters84014443goit_ers
gooseherd1442673gooseherd
gopher1239183go_pher_
gophers1338983go_phers
goutier82612353goutier_
graphed1498473graphe_d
grated84523923grat_e_d
grater74625443grat_er_
graters85419743grat_ers
heather133914853heather_
heathered16149463heathered
heathers143914733heathers
heathery17349083heathery
hothead14349293ho_thead
lathed104718453_lathe_d
lather95124353_lather_
lathered121512323_lathered
lathers104321883_lathers
lathery133911123_lathery
leather103815783leather_
leathered13148713leathered
leathern11398913leathern
leathers114215083leathers
leathery14438973leathery
loathe94211383loathe__
loathes103513243loathe_s
meathead1436793meathead
moated94819003moat_e_d
mother113718643mo_ther_
mothered142310103mo_thered
mothers123717623mo_thers
mothery153710513mo_thery
mouthed133811043mouthe_d
mouther123812813mouther_
mouthers133811303mouthers
neatherds1395773neatherds
norther1039733norther_
northern1145583northern
northers1139333northers
nother93815963no_ther_
oater55433733_oat_er_
oaters65029793_oat_ers
other84219103_o_ther_
others93918003_o_thers
outheard1288543_outheard
poached154212403poache_d
poacher143912323poacher_
poachers152910763poachers
pothead133810393po_thead
pother113818853po_ther_
potherb14358683po_therb
pothered142311043po_thered
pothers123818623po_thers
potsherd1434813potsherd
rather94319743_rather_
roached133211833roache_d
scathed134012643scathe_d
slather103816073slather_
slathered13148543slathered
slathers113914783slathers
softhead1545003softhead
soothed113712743soothe_d
soother104215043soother_
soothers113913433soothers
southed114313993southe_d
souther104116303souther_
southern11438913southern
southers114214453southers
spathed134013183spathe_d
swanherd1533483swanherd
swathed144611933swathe_d
swather134213603swather_
swathers144512083swathers
toothed113310243toothe_d
tother94117143to_ther_
weather133513223weather_
weathered16168513weathered
weathers143412833weathers
worthed1437873worthe_d
wrathed14298523wrathe_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 Filter1786911461620.423422437.4
2DLD Change Limit1461621477.39019778.3
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.87622688.0
 
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.