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

74 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
upgather1415275(None) 
upgathers1582531upgathers
gather104115852__gather
ingather1244782ingather
regather1236732regather
updater10347252updat_er
upgathered1742022upgathered
aweather1434263aweather
bather115322513__bather
blather125314203_blather
breather133610593breather
father125116713__father
feather133613503_feather
forgather1643663forgather
gasher104320373__gasher
gater64533653__gat_er
gathers114315073__gathers
heather133914853_heather
ingathers1344453ingathers
lather95124353__lather
leather103815783_leather
loather103711003_loather
megathere1544733megathere
negater83711963negat_er
panther12611443_panther
patcher143515143_p_atcher
pater74740723_p_at_er
patter84628263_p_atter
patzer173111643_p_atzer
peacher144216073_peacher
peatier94017233_peatier
phatter123810203_phatter
plasher124215033_plasher
plater84427693_plat_er
platier93716293_platier
platter93917413_platter
pleather1356653pleather
poacher143912323_poacher
pother113818853_p_other
prater84825353_prat_er
rather94319743__rather
regathers1336353regathers
sheather1458233sheather
slather103816073_slather
spathe115115693sp_athe_
spathed134013183sp_athed
spathes125116533sp_athes
spatter94016523sp_atter
splasher1335663splasher
splatter10348883splatter
sunbather1443023sunbather
swather134213603_swather
together1243743together
unbathed1437223unbathed
ungated92717213ungat_ed
untether1145163untether
update93810293updat_e_
updated11369423updat_ed
updaters11255183updat_ers
updates10329793updat_es
upgathering1842203upgathering
upgaze1833543upga_ze_
upgazed2033423upga_zed
upgazes1933573upga_zes
uplander1145533uplander
upraiser10175843upraiser
uprate83916543uprat_e_
uprated103213323uprat_ed
uprates93814863uprat_es
upsetter1034643upsetter
upstager11164633upstager
upstater10156663upstater
weather133513223_weather
wreather14268603wreather

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 Limit146162746.70321805.5
3Display Results74740.0332242.4
 (SQL Overall)178691747.15924960.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.