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

200 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
regather123673(None) 
regathers1336351regathers
breather133610592bre_ather
feather133613502fe_ather
foregather1743662foregather
gather104115852__gather
heather133914852he_ather
ingather1244782ingather
leather103815782le_ather
megathere1544732megathere
negater83711962negat_er
rather94319742r__ather
reacher123718292re_acher
rebater93517912rebat_er
regainer9249352regainer
regaler83814622rega_ler
regathered15124572regathered
relater73723142relat_er
upgather14152752upgather
weather133513222we_ather
wreather14268602wre_ather
aether94213673ae__ther
aweather1434263aweather
bather115322513__bather
beater84729393be_at_er
begetter11136313begetter
betatter1035453betatter
blather125314203_blather
breacher153011503bre_acher
breathe123711843bre_athe_
breathed14469643bre_athed
breathers14319103bre_athers
breathes134212903bre_athes
breathier1435383bre_athier
debater104114693debat_er
degasser10325813degasser
detacher1437543detacher
dewater112912423dewat_er
eater54639843_e_at_er
either94517423_e_ither
elater64724203_elat_er
ergate7315143ergat_e_
ergates8314493ergat_es
ether84518773_e__ther
father125116713__father
feater95224053fe_at_er
feathers143513243fe_athers
feathery17368073fe_athery
forefather1943573forefather
foregathers1843223foregathers
forgather1643663forgather
gasher104320373__gasher
gater64533653__gat_er
gathers114315073__gathers
greater84416493gre_at_er
heater94828303he_at_er
heathen133410893he_athen
heathers143914733he_athers
heathery17349083he_athery
heathier1438343he_athier
ingathers1344453ingathers
lather95124353__lather
leacher124014843le_acher
leathern11398913le_athern
leathers114215083le_athers
leathery14438973le_athery
legate72917453legat_e_
legated92513983legat_ed
legatee82814633legat_ee
legatees9258433legatees
legates82917683legat_es
legator83011133legat_or
loather103711003_loather
meatier93214613me_atier
megatheres1644853megatheres
neater64424313ne_at_er
neatherd12107193ne_atherd
negate72915573negat_e_
negated93413233negat_ed
negaters9349783negat_ers
negates83215843negat_es
negator83010673negat_or
neither1037573ne_ither
nether94014163ne__ther
peacher144216073pe_acher
peatier94017233pe_atier
pleather1356653pleather
preacher153211373pre_acher
rasher95024123r__asher
rater54943283r__at_er
rathe85821923r__athe_
ratter64326313r__atter
reached134619083re_ached
reachers133515723re_achers
reaches123423203re_aches
reader73628293re_a_der
readier83117423re_adier
realer63528593re_a_ler
realter73716313re_alter
reamer84325213re_a_mer
reaper84223143re_a_per
rearer64928913re_a_rer
reaver94524733re_a_ver
rebate84424113rebat_e_
rebated103619703rebat_ed
rebaters103413943rebat_ers
rebates95123183rebat_es
rebutter10106273rebutter
recaller1039323recaller
recamier1237603recamier
recanter101913153recanter
reciter94117263recit_er
redate74124683redat_e_
redated93120923redat_ed
redates83423873redat_es
reenter73217793reent_er
refuter104312193refut_er
regained102111243regained
regainers10237383regainers
regale74821453rega_le_
regaled93615963rega_led
regalers94311133rega_lers
regales83520793rega_les
regarded11279803regarded
regathering1645203regathering
regatta835963regat_ta
regattas944473regattas
regauge945813regauge_
regauged1135143regauged
regauges1046093regauges
regave104713383rega_ve_
register939553register
regrate82618663regrat_e_
regrated102816333regrat_ed
regrates92618403regrat_es
regretter1045973regretter
rehabber1563153rehabber
rehammer1544653rehammer
rehashed1536063rehashed
rehashes1436953rehashes
reheater113413033reheat_er
reinter73116843reint_er
relapser1035273relapser
relate64033633relat_e_
related83327573relat_ed
relaters83218153relat_ers
relates73731433relat_es
relator74016363relat_or
relaxer143410223rela_xer
reletter81311023reletter
remaker133813173rema_ker
remarker14178493remarker
remaster10311473remaster
rematched1745223rematched
rematches1636653rematches
remate84428683remat_e_
remated103522473remat_ed
remates93827113remat_es
remitter102810323remitter
remoter94815973remot_er
renature839323renature
renter64527413re_nt_er
rentier73618223re_ntier
repairer1036783repairer
repaper11310023repa_per
repatched1745313repatched
repatches1636713repatches
repattern1143663repattern
repeater102615443repeat_er
resetter81511833resetter
rester63832433re_st_er
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retarder9229433retarder
reutter71010093re_utter
revamper1533533revamper
rewarder12208233rewarder
rewashed1546243rewashed
rewashes1447033rewashes
righter113212383right_er
rugate75813813rugat_e_
seater64534153se_at_er
sedater83713623sedat_er
sheather1458233sheather
slather103816073_slather
swather134213603_swather
teacher123714833te_acher
teether10349693te_ether
tether93716103te__ther
together1243743together
treater74219833tre_at_er
upgathers1582533upgathers
weathers143412833we_athers
wether123315393we__ther
wreathe13339053wre_athe_
wreathed15257463wre_athed
wreathen14256143wre_athen
wreathers15257493wre_athers
wreathes14299893wre_athes

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.1561145455.1
2DLD Change Limit1461622007.75018859.6
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.98222386.7
 
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.