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

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

75 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
woolgatherings22778(None) 
woolgathering216971woolgathering_
woolgatherers206463woolgather_ers
foregathering2151954foregathering_
forgathering2052194_forgathering_
gatherings15105294____gatherings
ingatherings17101604__ingatherings
weatherings1895264w___eatherings
woolgatherer196544woolgather__er
blathering16107585__bl_athering_
featherings18105375___featherings
gathering1499465____gathering_
godfathering2151465_godfathering_
ingathering16103015__ingathering_
lathering13912255___l_athering_
leathering1488685___leathering_
motherings16255645_mo___therings
regathering1645205__regathering_
slathering14108285__sl_athering_
upgathering1842205__upgathering_
waterings13229255w____at_erings
weathering1798355w___eathering_
athelings1345116_____athelings
blattering13108716__bl_attering_
blethering16115936__bl_ethering_
blithering16116126__bl_ithering_
bolstering1346886_bol_st_ering_
bothering152210206_bo___thering_
brothering1646036bro___thering_
clattering13109236__cl_attering_
craterings1346006___crat_erings
elaterins9410036__el_at_erin_s
fathering161010096____fathering_
feathering17108796___feathering_
flattering1498746__fl_attering_
foregathers1843226foregather___s
forgathers1743556_forgather___s
godmothering2051576_godmothering_
gutterings12224916____gutterings
holstering1447086_hol_st_ering_
lathings12469856___l_ath__ings
lawyerings1752586___l_awyerings
layerings13235686___l_a_yerings
letterings11226006___l_etterings
loathings1344216___loath__ings
lobsterings1442896_lo_bst_erings
longshorings1751186_long_shorings
mothering152110186_mo___thering_
orienteerings1461596_orienteerings
oysterings1443906__o_yst_erings
plasterings1444746__pl_asterings
pothering151911286_po___thering_
scatterings14103976___scatterings
scouthering1743486sco__uthering_
slithering1496896__sl_ithering_
sloganeering1451646slo_ganeering_
smatterings14103846___smatterings
smothering1646016smo___thering_
soldierings1352156_sol__dierings
sonneteerings14151386_sonneteerings
splattering1454546_spl_attering_
toolmakings1851746toolma___kings
unflattering1672046unfl_attering_
volunteering1652156_volunteering_
wallpapering2061126wallpa_pering_
wanderings15215836w____anderings
watering122316316w____at_ering_
weatherizes2645946w___eatherizes
weltering13219496w_el__t_ering_
withering16108816w____ithering_
wolverines1654226w_ol___verines
woodcuttings19111086woodcut__tings
wuthering1697806w____uthering_
zoolaters1844986zool_at_er___s
zoolatries1943676zool_at__ri_es

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790759.15613629.3
3Display Results75750.0461630.4
 (SQL Overall)178691759.59218629.2
 
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.