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

64 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
goatherds144420(None) 
goatherd1335261goatherd_
gathers114315072g_ather_s
loathers113310442loather_s
neatherds1395772neatherds
bathers124720363_bather_s
blathers134713793blather_s
boaters93419243boat_er_s
boatyards1543963boatyards
boltheads1545123boltheads
bothers124317753bo_ther_s
catheads1438123_catheads
coachers154312303coacher_s
coaters93525793coat_er_s
coattends1243913coattends
cowherds1735423co_wherds
fatheads1536763_fatheads
fathers133916503_father_s
feathers143513243feather_s
flatheads1644873flatheads
gaters74728643g_at_er_s
gather104115853g_ather__
gathered13149373g_athered
gatherer12147903g_atherer
gatherers13156883g_atherers
gearheads1444083gearheads
giltheads1443123giltheads
gloaters9288863gloat_er_s
goateed9307063goat_eed_
goatees82710443goat_e_es
godfathers1852163godfather_s
godheads1443983go_dheads
goiters84014443goit_er_s
gooseherds1562173gooseherds
gophers1338983go_pher_s
graters85419743grat_er_s
heathers143914733heather_s
hotheads15318013ho_theads
lathers104321883_lather_s
leathers114215083leather_s
loathed11419443loathe_d_
loather103711003loather__
loathes103513243loathe__s
meatheads1545963meatheads
mothers123717623mo_ther_s
mouthers133811303mouther_s
neatherd12107193neatherd_
northerns1244933northerns
northers1139333norther_s
oaters65029793_oat_er_s
others93918003_o_ther_s
poachers152910763poacher_s
potheads14298543po_theads
potherbs15387123po_therbs
pothers123818623po_ther_s
potsherds1544023potsherds
slathers113914783slather_s
softheads1644553softheads
soothers113913433soother_s
southerns12347213southerns
southers114214453souther_s
swanherds1642543swanherds
swathers144512083swather_s
weathers143412833weather_s

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 Filter1786911486410.420425454.8
2DLD Change Limit148641646.97021325.8
3Display Results64640.0302133.3
 (SQL Overall)178691647.42024082.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.