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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
sheepfold185199(None) 
sheepfolds1951531sheepfolds
sevenfold1691553sevenfold
sheenful1443613sheenful_
sheepcot15114253sheepco_t
sheepcote16112783sheepcote
sheepcots1682683sheepcots
sheepdog1542363sheepdo_g
sheepdogs1642223sheepdogs
sheephead1863893sheephead
sheepwalk2152473sheepwalk
sheetfed1544143sheetf_ed
threefold1652113threefold
cheekful2042824cheekful_
cheekfuls2142434cheekfuls
cheeped153410594cheep__ed
cheerful1643984cheerful_
enfold10137614___enfold
eyefold1443344__eyefold
fivefold1852554five_fold
freehold1554684free_hold
gatefold1343544gate_fold
heedful1444314_heedful_
helpful1543964_helpful_
interfold13137484interfold
ninefold1243244nine_fold
onefold1144494_one_fold
peephole1545984_peephole
refold103812114__re_fold
scaffold1742234s_caffold
seafood1146154s__eafood
seedpod1144014s_eedpo_d
seeped94317524s_eep__ed
shampooed1742944shampooed
sheafed14388974sh_eaf_ed
sheened113511704shee__ned
sheep105321524sheep____
sheepcotes17112494sheepcotes
sheepheads1943654sheepheads
sheepish1645414sheep_ish
sheepishly2152364sheepishly
sheepman1543854sheep_man
sheepmen1544644sheep_men
sheepshead1961944sheepshead
sheepskin1851994sheepskin
sheepwalks2252344sheepwalks
sheered113515454shee__red
sheerly13337704shee__rly
sheeted113813044shee__ted
sheetrock1862834sheetrock
shelfful1742424shelfful_
shelffuls1851704shelffuls
sheol84318374sh_e__ol_
sheols94614164sh_e__ols
shepherd1744374sh_epherd
shield106212974shie___ld
shipload1464344sh_ipload
shlepped1633644shlep_ped
sixfold1842724s__ixfold
sleepily1344824sleep_ily
sleepwalk1852074sleepwalk
sneerful1143554sneerful_
steeped103412284steep__ed
steepened1244074steepened
steeple937324steep__le
steepled1135904steep_led
steeply1236294steep__ly
supersold1277444supersold
tenfold1145714__tenfold
theelol1044274thee_lol_
theelols1144414thee_lols
threshold1642914threshold
upfold12124954___upfold
wheeped16387504wheep__ed
wheeple1534854wheep__le
wheepled1733294wheep_led

Search took 13 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 Filter1786911653290.440406115.9
2DLD Change Limit1653297612.06313705.5
3Display Results76760.0461652.2
 (SQL Overall)1786917612.54914239.5
 
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.